Multiple choice

An index is clustered, if

  1. it is on a set of fields that form a candidate key

  2. it is on a set of fields that include the primary key

  3. the data records of the file are organised in the same order as the data entries of the index

  4. the data records of the file are organised not in the same order as the data entries of the index
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Clustered index is built on ordering non-key field and hence, if the index is clustered, then the data records of the file are organised in the same order as the data entries of the index.

Keep practicing — related questions