Anonymous user menu

A file is organized so that the ordering of data records is the : GATE 2015(1)

A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index. Then that index is called:
(A) Dense                                                 (B) Sparse
(C) Clustered                                            (D) Un-clustered

Answer

ANSWER : (A)

EXPLANATION:

According to the given question, we can say that each data record in the data file has one entry in the index file. So it must be dense index.

This is the defination of Clustered index.

When is a file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index, we say that the index is clustered.

given in database management system-by Raghu Ramakrishnan BOOK
 

1Comment
Mohit Lalwani @monty12
11 Feb 2016 07:27 pm

this is the defination of Clustered index........

When is a file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index, we say that the index is clustered.

given in database management system-by Raghu Ramakrishnan BOOK