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.

Question

Quizplus · Accepted Answer

A cylinder split does not necessarily lead to an increase in the number of levels of the index tree. The structure of a B+-tree allows it to accommodate changes in the data without necessarily increasing the tree's height. The redistribution of entries or splitting of nodes can often be absorbed within the existing levels of the tree.

All of the Following Are True About B+-Tree Indexes and Their