a) The system adds a pointer to the new record in the index entry
View QuestionInsertion of a large number of entries at a time into an index is referred to as __________ of the index
a) Loading b) Bulk insertion c) Bulk loading d) ...
View QuestionIn B+ tree the node which points to another node is called
a) Leaf node b) External node c) Final node d) Internal node Answer: d Explanation: ...
View QuestionA search key containing more than one attribute is referred to as a _________ search key.
a) Simple b) Composite c) Compound d) Secondary Answer: ...
View QuestionIncase the indices values are larger, index is created for these values of the index. This is called
a) Pointed index b) Sequential index c) Multilevel index
View QuestionIn a __________ index, an index entry appears for only some of the search-key values.
a) Dense b) Sparse c) Straight d) ...
View QuestionIn 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: ...
View QuestionAn ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
a) Index entry b) Index hash c) Index cluster d) ...
View QuestionIndices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
a) Nonclustered b) Secondary c) All of ...
View QuestionIn ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
a) Clustered index b) Structured index c) Unstructured index d) ...
View Question