Which two statements about the above index are true?

Examine the following output:
SQL> SELECT index_name,status
FROM dba_indexes
WHERE status=’UNUSABLE’;
INDEX_NAME STATUS
————————– —————
EIND UNUSABLE
Which two statements about the above index are true? (Choose two.)

Examine the following output:
SQL> SELECT index_name,status
FROM dba_indexes
WHERE status=’UNUSABLE’;
INDEX_NAME STATUS
————————– —————
EIND UNUSABLE
Which two statements about the above index are true? (Choose two.)

A.
The index is automatically rebuilt when used the next time.

B.
The index cannot be rebuilt, and has to be re-created.

C.
It is ignored by the query optimizer.

D.
It is not used while the index is being rebuilt.



Leave a Reply 1

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


seenagape

seenagape

I choose CD