Machine-translated by Google. Questions are authored in English.
Top

Discussion

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.Unclustered

Answer: C

The index is called Clustered.

A clustered index is one whose order matches, or nearly matches, the physical order of the data records in the file. Range searches on it are efficient because matching records sit together on the disk.

An unclustered index has a different order from the data. Dense and sparse describe whether there is an index entry for every record or only for some, not how the order compares.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.