The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）A、ALTER TABLE employees monitor index employee_idx_fk; B、ALTER INDEX em

题目

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

  • A、ALTER TABLE employees monitor index employee_idx_fk; 
  • B、ALTER INDEX employee_idx_fk monitoring on; 
  • C、ALTER TABLE employees monitor all indexes; 
  • D、ALTER INDEX employee_idx_fk monitoring usage; 
相似考题

1.A key to successful Management by Objectives (MBO) isA . insuring that employees have clearly defined objectivesB . involving employees in decision meetingsC . permitting employees to set their own objectivesD . allowing employees to perform. their own evaluationsE . A or C.

2.有个员工表employees,该表中有职务列。你想检查哪些员工的信息中没有填写职务一栏,应该使用()。A.Select*from employees where职务＝NULLB.Select*from employees where职务=‘NULL’C.Select*from employees where职务ISNULLD.Select*from employees where职务IS‘NULL’

3.Which two statements complete a transaction? ()A. DELETE employees;B. DESCRIBE employees;C. ROLLBACK TO SAVE POINT C;D. GRANT SELECT ON employees TO SCOTHE. ALTER TABLE employees SET UNUSED COLUMN sal;F. Select MAX(sal) FROM employees WHERE department _ id 20;

4.197 A key to successful Management by Objectives (MBO) isA. insuring that employees have clearly defined objectivesB. involving employees in decision meetingsC. permitting employees to set their own objectivesD. allowing employees to perform. their own evaluationsE. A or C

更多“The EMPLOYEES table&”相关问题

  • 第1题：

    Examine the data in the EMPLOYEES table:Which three subqueries work? ()

    A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

    B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

    F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));


    参考答案：C, D, E

  • 第2题：

    Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?()

    A.

    B.

    C.

    D.


    参考答案：A

  • 第3题：

    Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()

    A.SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

    B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

    C.SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

    D.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

    E.SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);

    F.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));


    参考答案：C, D, E

  • 第4题：

    Which two statements complete a transaction? （）

    • A、DELETE employees;
    • B、DESCRIBE employees;
    • C、ROLLBACK TO SAVEPOINT C;
    • D、GRANT SELECT ON employees TO SCOTT;
    • E、ALTER TABLE employees SET UNUSED COLUMN sal;
    • F、SELECT MAX(sal) FROM employees WHERE department_id = 20;

    正确答案:D,E

  • 第5题：

    于SQL Server 2000，下列BcP语句—定不正确的是（）

    • A、bcp“northwind.dbo.employees"out”employees.txt"-C-q-U”，sa”-P”sa”
    • B、bcp“northwind.dbo.employees"to“emptoyees.txt"-c-q-U”sa”-P”sa”
    • C、bcp”northwind.dbo.employees"in“employees.txt"-c-q-U"sa”-P”sa”
    • D、bcp“northwind.dbo.employees"from“employees.txt”-c-q-U”sa”-P”sa”

    正确答案:B,D

  • 第6题：

    Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）

    • A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
    • B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
    • C、SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
    • D、SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
    • E、SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
    • F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

    正确答案:C,D,E

  • 第7题：

    多选题
    Examine the data in the EMPLOYEES table: Which three subqueries work? （）
    A

    SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

    B

    SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    C

    SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    D

    SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    E

    SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

    F

    SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));


    正确答案： D,E
    解析： 暂无解析

  • 第8题：

    单选题
    Defining employee “customer” segments means
    A

    offering some employees more and the other less.

    B

    relating the customers to the employees’ benefits.

    C

    varying benefits according to different employees.

    D

    dividing employees into different groups.


    正确答案： B
    解析：
    把define employee “customer”segments定位在文中第四段第四行。该段首句为中心句，提到“…employers should tailor their investment in benefits to the preferences of their employees…”，即“雇主应该根据员工的不同喜好来进行福利投资”。可以推断该短语意思应该为“把员工划分为不同的需求群体，故选项D符合题意。

  • 第9题：

    单选题
    The EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace.  Which object will be exported by this command？（）   exp system/manager tablespaces=SAMPLE
    A

    Only the EMPLOYEES table.

    B

    Only the EMPLOYEES table and its corresponding primary key index.

    C

    The EMPLOYEES table and partition P1.

    D

    The EMPLOYEES table， IPK_EMP index， and the SALES table.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）
    A

    MERGE

    B

    INSERT

    C

    UPDATE

    D

    ADD

    E

    ENTER

    F

    You cannot enter the phone numbers for the existing employee records.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）
    A

    INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

    B

    INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

    C

    INSERT INTO employees VALUES ('1000','JOHN','NULL');

    D

    INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

    E

    INSERT INTO employees (employee_id) VALUES (1000);

    F

    INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);


    正确答案： A,F
    解析： 暂无解析

  • 第12题：

    单选题
    In the passage, the following advantages of casual office wear are mentioned EXCEPT _____.
    A

    saving employees’ money

    B

    making employees more attractive

    C

    improving employees’ motivation

    D

    making employees happier


    正确答案： A
    解析：
    信息题。A选项“节省员工的开销”和原文第三段“casual dress code helps them save money”相符；B选项“让员工看起来更加有吸引力”未在文中提及；C选项“提升员工的动力”和原文“casual dress improves employee morale”相符；D选项“让员工心情更愉悦”体现在原文“people seem happier and more productive when they are wearing comfortable clothes”。

  • 第13题：

    Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?()

    A. To find the tax percentage for each of the employees.

    B. To list the name, job id, and manager name for all the employees.

    C. To find the name, salary, and department name of employees who are not working with Smith.

    D. To find the number of employees working for the Administrative department and earning less then 4000.

    E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.


    参考答案：A

  • 第14题：

    Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work? ()

    A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

    B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

    F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));


    参考答案：C, D, E

  • 第15题：

    Which two statements complete a transaction?（）

    • A、DELETE employees;
    • B、DESCRIBE employees;
    • C、ROLLBACK TO SAVE POINT C;
    • D、GRANT SELECT ON employees TO SCOTH
    • E、ALTER TABLE employees SET UNUSED COLUMN sal;
    • F、Select MAX(sal) FROM employees WHERE department _ id 20;

    正确答案:D,E

  • 第16题：

    有个员工表employees，该表中有职务列。你想检查哪些员工的信息中没有填写职务一栏，应该使用（）。

    • A、Select*from employees where职务＝NULL
    • B、Select*from employees where职务=‘NULL’
    • C、Select*from employees where职务ISNULL
    • D、Select*from employees where职务IS‘NULL’

    正确答案:C

  • 第17题：

    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?（）

    • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
    • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
    • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
    • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

    正确答案:C

  • 第18题：

    单选题
    When preparing benefit changes, companies should
    A

    treat employees as customers.

    B

    stress the benefits of the changes.

    C

    talk employees into accepting the changes.

    D

    act quickly according to the reactions of employees.


    正确答案： A
    解析：
    该题问的是“准备进行福利改动的时候，公司应该怎么做”。文中第五段第二句指出“Companies should approach them with the same caution that consumers get...”，与选项A意思相符。

  • 第19题：

    多选题
    Which three statements inserts a row into the table?（）
    A

    INSERT INTO employees   VALUES ( NULL, ‘John’,‘Smith’);

    B

    INSERT INTO employees( first_name, last_name)   VALUES(‘John’,‘Smith’);

    C

    INSERT INTO employees   VALUES (‘1000’,‘John’,NULL);

    D

    INSERT INTO employees(first_name,last_name, employee_id)   VALUES ( 1000, ‘John’,‘Smith’);

    E

    INSERT INTO employees (employee_id)   VALUES (1000);

    F

    INSERT INTO employees (employee_id, first_name, last_name)   VALUES ( 1000, ‘John’,‘’);


    正确答案： D,B
    解析： 暂无解析

  • 第20题：

    多选题
    Which two statements complete a transaction?（）
    A

    DELETE employees;

    B

    DESCRIBE employees;

    C

    ROLLBACK TO SAVEPOINT C;

    D

    GRANT SELECT ON employees TO SCOTT;

    E

    ALTER TABLE employees   SET UNUSED COLUMN sal;

    F

    Select MAX(sal)   FROM employees   WHERE department_id = 20;


    正确答案： C,E
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements complete a transaction? （）
    A

    DELETE employees;

    B

    DESCRIBE employees;

    C

    ROLLBACK TO SAVE POINT C;

    D

    GRANT SELECT ON employees TO SCOTH

    E

    ALTER TABLE employees SET UNUSED COLUMN sal;

    F

    Select MAX(sal) FROM employees WHERE department _ id 20;


    正确答案： B,F
    解析： 暂无解析

  • 第22题：

    单选题
    Your company hires 10 new employees. You want the new employees to connect to the main office through a VPN connection. You create new user accounts and grant the new employees the Allow Read and Allow Execute permissions to shared resources in the main office. The new employees are unable to access shared resources in the main office. You need to ensure that users are able to establish a VPN connection to the main office What should you do（）
    A

    Grant the new employees the Allow Full control permission.

    B

    Grant the new employees the Allow Access Dial-in permission.

    C

    Add the new employees to the Remote Desktop Users security group.

    D

    Add the new employees to the Windows Authorization Access security group.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid? （）
    A

    DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);

    B

    DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);

    C

    DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'

    D

    DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'


    正确答案： A
    解析： 暂无解析

  • 第24题：

    问答题
    MegaTech and UltraCorp are considering a merger to form the MegaUltraTech Corporation. Does MegaTech have more employees than UltraCorp?　　(1) The average (arithmetic mean) age of UltraCorp employees is 32.8, while the average age of MegaTech employees is 27.2.　　(2) If the merger goes through and all employees from both companies remain employed, the average (arithmetic mean) age of the MegaUltraTech employees will be 31.4.

    正确答案： C
    解析：
    条件1、2中均不涉及两个公司的员工数量，但是将两者综合可以推断出UltraCorp的员工数大于MegaTech，故本题选C项。

相关内容