MadeEasy Test Series: Databases - Indexing

Question

#DBMS

Which of the following statements is/are true?

(A) For any data file it is possible to construct two separate sparse first level indexes on different keys.

(B) For any data file, it is possible to construct two separate dense first level indexes on different keys.

(C) For any data file, it is possible to construct a sparse first level index and a dense second level index both should be useful.

Comments

@ Abhishek Kumar Singh,@ Bad_Doctor

Can't get you both ! Spare index is always meant for blocks and i gave an exception which should not consider here because its not a generalize case.

---

I was saying that suppose both serial ID and student ID together is a key. So some of the values of serial ID may be repeating and some of the values of student ID may be repeating. Now I made a sparse index on student ID by pointing to first pointer to first unique value second pointer to second unique value of student ID and so on. In this way we can get a sparse index pointing to each block of student ID. Similarly for serial ID.

---

I think both (A) and (B) are possible, while option (C) doesn't make any sense.