Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 213

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

You use ALTER INDEX to make an INVISIBLE index VISIBLE.

An INVISIBLE index consumes no storage.

The query optimizer never considers INVISIBLE indexes when determining execution plans.

You can only create one INVISIBLE index on the same column list.

All INSERT, UPDATE, and DELETE statements maintain entries in the index.

Correct Answer: A, E

You use ALTER INDEX to make an INVISIBLE index VISIBLE, and all INSERT, UPDATE, and DELETE statements maintain entries in the index. Though invisible indexes are not used by the query optimizer by default for execution plans, they still exist and consume storage, and they are maintained by the database during data manipulation operations.

Discussion

jm9999Options: AE

For C, the query optimizer usage is based on the setting of OPTIMIZER_USE_INVISIBLE_INDEXES

Alex72Options: AC

A, C are correct. E. The maintenance of entries in the index during data manipulation operations (INSERT, UPDATE, DELETE) is not impacted by the visibility of the index. Both VISIBLE and INVISIBLE indexes are updated accordingly to maintain data integrity and facilitate efficient data retrieval using indexes.

benjamin2023

C is not correct because the word "never". E is correct because invisible index is still maintained by the database with DML.