|
Explanation: This statement provide correct syntax to start monitoring the EMPLOYEE_IDX_FK ndex to determine whether it has been used by an execution plan. Incorrect Answers: 1: This command requires MONITORING USAGE clause with ALTER INDEX ommand to be used, not MONITOR INDEX clause with ALTER TABLE command. 2: This command requires MONITORING USAGE clause to be used, not ONITORING ON clause. 3: This command requires MONITORING USAGE clause with ALTER INDEX command to be used, not MONITOR ALL INDEXES clause with ALTER TABLE command. Reference: 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
|