Solved

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

Question 18

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

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents