Exam 1z0-071 topic 1 question 222 discussion

Actual exam question from Oracle's 1z0-071

Question #: 222
Topic #: 1

[All 1z0-071 Questions]

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

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.

Show Suggested Answer

Suggested Answer: AE 🗳️

by Alex72 at Aug. 2, 2023, 1:14 a.m.

Comments

Submit Cancel

jm9999

10 months, 2 weeks ago

Selected Answer: AE

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

upvoted 2 times

...

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.

upvoted 2 times

benjamin2023

7 months, 1 week ago

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

upvoted 1 times

...

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Exam 1z0-071 topic 1 question 222 discussion

Comments

jm9999

Alex72

benjamin2023

SY0-701