Exam 1z0-883 topic 1 question 33 discussion

Actual exam question from Oracle's 1z0-883

Question #: 33
Topic #: 1

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

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,

Show Suggested Answer

Suggested Answer: BDG 🗳️
Reference:
http://dev.mysql.com/doc/refman/5.0/en/innodb-index-types.html

by MohanBoss at April 26, 2021, 8:52 a.m.

Comments

Submit Cancel

MohanBoss

4 years, 1 month ago

E. A clustered index provides direct access to a page containing row data. This option is also correct as given in the link , Accessing a row through the clustered index is fast because the index search leads directly to the page that contains the row data.

upvoted 1 times

...