Which two statements regarding unusable indexes are correct?

Which two statements regarding unusable indexes are correct? (Choose two.)

Which two statements regarding unusable indexes are correct? (Choose two.)

A.
You can set SKIP_UNUSABLE_INDEXES to true to skip unusable indexes.

B.
You can check the alert log file to get a message recorded about unusable indexes.

C.
You do not need to set any parameter because unusable indexes are skipped automatically.

D.
Your Data Definition Language (DDL) statement shows a warning message when an index is made unusable.

Explanation:
Setting this parameter to TRUE disables error reporting of indexes and index partitions marked UNUSABLE.The SKIP_UNUSABLE_INDEXES, which in earlier releases was a session parameter,is now an initialization parameter with a default value of TRUE. In earlier releases default value of this parameter is false.

REF: Metalink Note: 281500.1- SKIP_UNUSABLE_INDEXES Initialization Parameter in Oracle Database 10g



Leave a Reply 1

Your email address will not be published. Required fields are marked *