Oracle Database MySQL 5.6 Database Administrator — Question 6

The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?

Answer options

• A. A primary key must exist for creation of a clustered index.
• B. A primary key is used as a clustered index.
• C. A clustered index is a grouping of indexes from different tables into a global index for faster searching.
• 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.
• F. The first unique index is always used as a clustered index and not a primary key.
• G. A clustered index allows fulltext searching within InnoDB,

Correct answer: B, D, G

Explanation

The correct answers B, D, and G accurately describe the characteristics of clustered indexes in InnoDB. B states that a primary key is utilized as a clustered index, which is true as the clustered index is based on the primary key. D explains that if there are no indexes, InnoDB generates a hidden clustered index with row IDs. G is correct because clustered indexes in InnoDB support full-text searching. The other options are incorrect as A, C, E, and F misrepresent how clustered indexes function.