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:

Verified
Correct Answer:
Verified
Q98: Taking application priorities into account in physical
Q99: In the adding new tables physical database
Q100: Application data requirements that enter into the
Q101: A "fixed" or "hard" disk drive operates
Q102: If the primary key of a table
Q104: Denormalization improves the performance of join operations
Q105: In the B+-tree index arrangement described in
Q106: Clustering files disperses logically related data from
Q107: Construct a B+-tree index of the type
Q108: A hashed file has space for 80