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:
Verified
Q13: All of the following are true about
Q14: In a magnetic disk device, the number
Q15: In a magnetic disk device, the number
Q16: Which of the following is true about
Q17: In a magnetic disk device, the reason
Q19: All of the following are true about
Q20: Direct access can be achieved _.
A) with
Q21: All of the following are good candidates
Q22: In a hashed file using the division
Q23: Hashed files _.
A) are stored in physical
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents