You have altered a non-unique index to be invisible to determine if queries execute within an
acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?
A.
The index remains invisible.
B.
The index is not updated by the DML statements on the indexed table.
C.
The index automatically becomes visible in order to have it updated by DML on the table.
D.
The index becomes unusable but the table is updated by the DML.
E.
The index is updated by the DML on the table.
Explanation:
Unlike unusable indexes, an invisible index is maintained during DML statements.Note:
* 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.
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.
Taking the legacy forward, invisible column concepts has been introduced in Oracle 12c R1
A and E
AE
A and E
AE
A, E
AE