Oracle
1Z0-061 · Question #123
Which statements are correct regarding indexes? (Choose all that apply.)
The correct answer is A. For each data manipulation language (DML) operation performed, the corresponding indexes are B. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a D. When a table is dropped, the corresponding indexes are automatically dropped. See the full explanation below for the reasoning.
Question
Which statements are correct regarding indexes? (Choose all that apply.)
Options
- AFor each data manipulation language (DML) operation performed, the corresponding indexes are
- BA nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a
- CA FOREIGN KEY constraint on a column in a table automatically creates a non unique key
- DWhen a table is dropped, the corresponding indexes are automatically dropped
How the community answered
(41 responses)- A83% (34)
- C17% (7)
Community Discussion
No community discussion yet for this question.