Oracle
1Z0-497 · Question #116
1Z0-497 Question #116: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-497 to reveal the answer and full explanation for question #116. The question stem and answer options stay visible for context.
Question
Examine the output: SQL> SELECT index_name, status FROM dba_indexes WHERE status='UNUSABLE'; INDEX_NAME STATUS --------------------- ----------------- EINDUNUSABLE Which two statements about this index are true?
Options
- AIt is ignored by the query optimizer.
- BIt is not used while the index is being rebuilt.
- CThe index cannot be rebuilt, and has to be re-created.
- DThe index is automatically rebuilt when used the next time.
Unlock 1Z0-497 to see the answer
You've previewed enough free 1Z0-497 questions. Unlock 1Z0-497 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.