1Z0-062 · Question #103
1Z0-062 Question #103: Real Exam Question with Answer & Explanation
The correct answer is A: The index remains invisible.. Unlike unusable indexes, an invisible index is maintained during DML statements. * Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES paramete
Question
Options
- AThe index remains invisible.
- BThe index is not updated by the DML statements on the indexed table.
- CThe index automatically becomes visible in order to have it updated by DML on the table.
- DThe index becomes unusable but the table is updated by the DML.
- EThe index is updated by the DML on the table.
Explanation
Unlike unusable indexes, an invisible index is maintained during DML statements. * Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled using the ALTER INDEX command.
Community Discussion
No community discussion yet for this question.