Oracle
1Z0-047 · Question #141
Which statements are correct regarding indexes? (Choose all that apply.)
The correct answer is A. When a table is dropped, the corresponding indexes are automatically dropped. B. For each DML operation performed, the corresponding indexes are automatically updated. D. A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index. See the full explanation below for the reasoning.
Question
Which statements are correct regarding indexes? (Choose all that apply.)
Options
- AWhen a table is dropped, the corresponding indexes are automatically dropped.
- BFor each DML operation performed, the corresponding indexes are automatically updated.
- CIndexes should be created on columns that are frequently referenced as part of any expression
- DA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
How the community answered
(17 responses)- A76% (13)
- C24% (4)
Community Discussion
No community discussion yet for this question.