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

This question was addressed to me in my homework.

This is a very interesting question from Ordered Indices topic in portion Indexing and Hashing of Database Management

Answer 1

Right answer is (a) Clustered index

The best explanation: 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.