GATE | GATE CS 2013 | Question 15

An index is clustered, if
(A) it is on a set of fields that form a candidate key.
(B) it is on a set of fields that include the primary key.
(C) the data records of the file are organized in the same order as the data entries of the index.
(D) the data records of the file are organized not in the same order as the data entries of the index.


Answer: (C)

Explanation: A database index is clustered if physical records on disk follow the index order.

Quiz of this Question

My Personal Notes arrow_drop_up

Save