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