Multiple Choice
All of the following are true about B+-tree indexes and their files, except _____.
A) A file with a B+-tree index built over the field by which the file is stored in sequence is an indexed sequential file.
B) A track split might lead to a cylinder split.
C) A track split might not lead to a cylinder split.
D) A cylinder split must lead to a change in the tree index.
E) A cylinder split must lead to an increase in the number of levels of the index tree.
Correct Answer:

Verified
Correct Answer:
Verified
Q34: The common advantage of separating portions of
Q35: The frequency with which stored data is
Q36: In a hashed file, synonym pointer chains
Q37: <span class="ql-formula" data-value="\begin{array}{lllll}\begin{array}{lll}\text { Course } \quad\quad
Q38: The way that data is stored for
Q40: A cylinder is a collection of contiguous
Q41: One of the main potential problems in
Q42: Storing derived data improves performance in the
Q43: A record insertion in a B+-tree index
Q44: Direct access can be achieved _.<br>A) with