Oracle Database SQL — Question 163

Which two statements about INVISIBLE indexes are true? (Choose two.)

Answer options

• A. You use ALTER INDEX to make an INVISIBLE index VISIBLE.
• B. An INVISIBLE index consumes no storage.
• C. The query optimizer never considers INVISIBLE indexes when determining execution plans.
• D. You can only create one INVISIBLE index on the same column list.
• E. All INSERT, UPDATE, and DELETE statements maintain entries in the index.

Correct answer: A, E

Explanation

Option A is correct because you can indeed use the ALTER INDEX command to change the visibility status of an INVISIBLE index. Option E is also correct as all data manipulation operations like INSERT, UPDATE, and DELETE will still maintain entries in the INVISIBLE index, contrary to what options B, C, and D suggest.