Go back to
1Z0-031 - Oracle9i Database: Fundamentals I
Question 103 You execute the following command on an index, SALES_ORDERS_INDX for the first time: SQL> ALTER INDEX sales_orders_indx MONITORING USAGE; Which task does this command accomplish?
It populates the index usage statistics in the INDEX_STATS view.
It displays the index usage statistics when a query uses the index.
It populates the index monitoring and usage statistics in the V$OBJECT_USAGE view.
It populates the index usage statistics in the alert log file.
Want to practice for 1Z0-031 - Oracle9i Database: Fundamentals I ?