Question

If the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

(a) Clustering data

(b) Cluttering index

(c) Clustering index

(d) Clustering number

The question was posed to me in class test.

The doubt is from Ordered Indices in section Indexing and Hashing of RDBMS

Answer 1

The correct choice is (b) Cluttering index

Easiest explanation: If the file containing the records is sequentially ordered, a Clustering index is an index whose search key also defines the sequential order of the file. Clustering indices are also called as primary indices but they do not denote an index on the primary key. Such indices can be built on any search key.