in Databases edited by
368 views
1 vote
1 vote

A file is organized so that the ordering of data record is same as or close to the ordering of data block in some index. Then that index is called

  1. Dense
  2. Sparse
  3. Clustered
  4. Unclustered 

Given answer is :- Sparse. Is it correct?

This is similar to https://gateoverflow.in/8222/gate2015-1_24 with some variation i highlighted

in Databases edited by
368 views

1 comment

Yes, I think the answer is correct. The indexing used is still clustered indexing, but it is clustered sparse indexing since the index entries now point to each data BLOCK instead of each data item.
0
0

Please log in or register to answer this question.

Related questions