To start and stop monitoring an index to determine usage, use which ALTER INDEX command clause?
A . START MONITORING/STOP MONITORING
B. MONITORING USAGE/NOMONITORING USAGE
C . START MONITORING USAGE/STOP MONITORING USAGE
D . START USAGE/STOP USAGE
Explanation:
Answer B: The MONITORING USAGE clause is used to both start and stop monitoring index usage. The V$OBJECT_USAGE view will indicate if the index was used during the monitoring period.
No comments:
Post a Comment