New Features for Administrators - Question 051

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;

Answer: D

Explanation:

This statement provide correct syntax to start monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan.

Incorrect Answers

A: This command requires MONITORING USAGE clause with ALTER INDEX command to be used, not MONITOR INDEX clause with ALTER TABLE command.

B: This command requires MONITORING USAGE clause to be used, not MONITORING ON clause.

C: This command requires MONITORING USAGE clause with ALTER INDEX command to be used, not MONITOR ALL INDEXES clause with ALTER TABLE command.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 212-214

Chapter 4: Performance and Scalability Enhancements

Oracle 9i New Features, Robert Freeman, p. 56-59

Chapter 2: Oracle9i Architecture Changes