Explanation:In a dense nonclustering index, the index must store a list of pointers to all records with the same search-key value. 5. In a __________ index, an index entry appears for only some of the search-key values.
A. Dense
B. Sparse
C. Straight
D. Continuous
Answer:A
Explanation:In a dense nonclustering index, the index must store a list of pointers to all records with the same search-key value. 5. In a __________ index, an index entry appears for only some of the search-key values.
A. Dense B. Sparse C. Straight D. Continuous
Explanation:Sparse indices can be used only if the relation is stored in sorted order of the search key, that is, if the index is a clustering index.