nerdexam
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)
  • A
    3% (1)
  • B
    76% (25)
  • C
    6% (2)
  • F
    3% (1)
  • G
    12% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice