Oracle
1Z0-047 · Question #228
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 an expression.
- DA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
How the community answered
(53 responses)- A83% (44)
- C17% (9)
Community Discussion
No community discussion yet for this question.