Question

An index is clustered,if

• A. the data records of the file are organized not in the same order as the data entries of the index
• B. it is on a set of fields that include the primary key.
• C. the data record of the file are organized in the same order as the date entries of the index
• D. it is on a set of fields that form a candidate key.

Answer 1

The correct option is C the data record of the file are organized in the same order as the date entries of the index

Clustered index sort the data in the table based on their key values of the column on which clustered index is created,
So option (c) is correct.