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;

参考答案和解析

正确答案:D

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

有个员工表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

第2题：

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

第3题：

A key to successful Management by Objectives (MBO) is

A . insuring that employees have clearly defined objectives

B . involving employees in decision meetings

C . permitting employees to set their own objectives

D . allowing employees to perform. their own evaluations

E . A or C.

正确答案：E

第4题：

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

第5题：

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

参考答案：A

第6题：

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;

参考答案：C, E

第7题：

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

第8题：

197 A key to successful Management by Objectives (MBO) is

A. insuring that employees have clearly defined objectives

B. involving employees in decision meetings

C. permitting employees to set their own objectives

D. allowing employees to perform. their own evaluations

E. A or C

正确答案：E

第9题：

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

第10题：

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

The EMPLOYEES table&

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容