Question

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

(a) Clustered index

(b) Structured index

(c) Unstructured index

(d) Nonclustered index

The question was asked by my school principal while I was bunking the class.

The query is from Bitmap Indices in section Indexing and Hashing of Database Management

Answer 1

Right answer is (a) Clustered index

The best I can explain: Clustering index are also called primary indices; the term primary index may appear to denote an index on a primary key, but such indices can in fact be built on any search key.