a) Dense
b) Sparse
c) Straight
d) Continuous
Answer: a
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.
Related Posts
While inserting the record into the index, if the search-key value does not appear in the index.
Insertion of a large number of entries at a time into an index is referred to as __________ of the index
In B+ tree the node which points to another node is called
A search key containing more than one attribute is referred to as a _________ search key.
Incase the indices values are larger, index is created for these values of the index. This is called
In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
Join The Discussion