If you have enabled MONITORING for an index, determine if the index can be dropped by querying which dynamic performance view?
A . V$SORT_USAGE
B . V$INDEX_USAGE
C . V$QUERY_USAGE
D . V$TABLE_USAGE
E. V$OBJECT_USAGE
Explanation:
Answer E: The V$OBJECT_USAGE view indicates if an index has been used during the monitoring period. You can enable monitoring for an index by using the ALTER INDEX "el" MONITORING USAGE clause. This is not a valid clause when creating the index.
No comments:
Post a Comment