Explanation:The pointer to a record consists of the identifier of a disk block and an offset within the disk block to identify the record within the block. 4. 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.
A. Dense
B. Sparse
C. Straight
D. Continuous
Answer:A
Explanation:The pointer to a record consists of the identifier of a disk block and an offset within the disk block to identify the record within the block. 4. 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.
A. Dense B. Sparse C. Straight D. Continuous
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.