Examine the output:
SQL> SELECT index_name, status FROM dba_indexes WHEREstatus=’UNUSABLE’;
INDEX_NAME STATUS
——————— —————–EINDUNUSABLE
Which two statements about this index are true?
A.
It is ignored by the query optimizer.
B.
It is not used while the index is being rebuilt.
C.
The index cannot be rebuilt, and has to be re-created.
D.
The index is automatically rebuilt when used the next time.
AB
how AB ?? B is not justified or stated logically anywhere even in oracle 12c docs https://docs.oracle.com/database/121/ADMIN/indexes.htm#ADMIN13279
http://docs.oracle.com/database/121/ADMIN/indexes.htm#ADMIN13279
A,B
how AB ?? B is not justified or stated logically anywhere even in oracle 12c docs https://docs.oracle.com/database/121/ADMIN/indexes.htm#ADMIN13279
AB