Oracle
1Z0-883 · Question #11
The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?
The correct answer is B. A primary key is used as a clustered index. D. If no indexes exist, a hidden clustered index is generated based on row IDs. E. A clustered index provides direct access to a page containing row data. See the full explanation below for the reasoning.
Question
The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?
Options
- AA primary key must exist for creation of a clustered index.
- BA primary key is used as a clustered index.
- CA clustered index is a grouping of indexes from different tables into a global index for faster searching.
- DIf no indexes exist, a hidden clustered index is generated based on row IDs.
- EA clustered index provides direct access to a page containing row data.
- FThe first unique index is always used as a clustered index and not a primary key.
- GA clustered index allows fulltext searching within InnoDB,
How the community answered
(33 responses)- A3% (1)
- B76% (25)
- C6% (2)
- F3% (1)
- G12% (4)
Community Discussion
No community discussion yet for this question.