Solved

All of the Following Are Advantages of the B+-Tree Index

Question 103

Multiple Choice

All of the following are advantages of the B+-tree index arrangement, compared to the simple linear index arrangement, except _____.


A) The upper portion of the tree index can be held in main memory indefinitely to improve performance.
B) The insertion of a new record requires either a track split or a cylinder split, but not both for a single insertion.
C) Even for large files, only a small number of index records have to be read for a direct search.
D) The nature of the index together with the track split and cylinder split capabilities make record insertions manageable.
E) Some insertions can be made without track splits or cylinder splits if reserve space has been provided on the data tracks.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions