Oracle
1Z0-514 · Question #36
Which two statements are true regarding indexes? (Choose two.)
The correct answer is B. An index can be created on one or more columns. D. Indexes are implicitly created by the PRIMARY KEY and UNIQUE constrains. See the full explanation below for the reasoning.
Question
Which two statements are true regarding indexes? (Choose two.)
Options
- Acolumn can have multiple indexes created on it.
- BAn index can be created on one or more columns.
- CIndex must be created in the same tablespace as the table.
- DIndexes are implicitly created by the PRIMARY KEY and UNIQUE constrains.
How the community answered
(59 responses)- A5% (3)
- B85% (50)
- C10% (6)
Community Discussion
No community discussion yet for this question.