Self Doubt

Question

A file is organized so that the ordering of the data records is the same as or close to the ordering of data entries in some index. Than that index is called

A file is organized so that the ordering of the data records is the same as ordering of data entries in some index. Than that index is called

 Options for both : 

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

ref :https://gateoverflow.in/8222/gate2015-1-24

Comments

If ordering is same as or close to ordering of data records, it should be Clustered Index.

If ordering is exactly same as ordering of data records, it should be Primary Index.