ISRO2018-51

Question

Which of the following is dense index?

• A. Primary index
• B. Clustered index
• C. Secondary index
• D. Secondary non-key index

Comments

Secondary index is dense index, option C is correct. Whereas, secondary non key index may or may not be dense index.

Answer 1

A. Primary index is maintain for the anchor value of block i,e one key value per block maintained in Index file.

B. Clustering index is basically mixed sort of Indexing i,e Dense as it is maintained for  unique value (key)  and Sparse as it is not maintained for every value.

C. Index is maintained for every key value so dense index.

ans. C

Comments

Index entry will be created for every search key value

Your example is clustered index

---

One more in support of options D

http://www.cs.montana.edu/~halla/csci440/n18/n18.html

---

So is this wrong:

http://www.eazynotes.com/pages/database-management-system/indexing.html

Answer 2

Ref: Navathe