Oracle
1Z0-071 · Question #34
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. 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 an expression.
- DA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a
How the community answered
(20 responses)- A75% (15)
- C25% (5)
Community Discussion
No community discussion yet for this question.