All of the following are true about B+-tree indexes and their files, except _____.
A) The records of the file are stored in order by key value.
B) Both a number of tracks and a number of cylinders are held empty in reserve for new record insertion purposes.
C) Every insertion of a new record requires the use of an empty reserve track or cylinder.
D) It is possible that a new record insertion can increase the number of levels of the index tree.
E) The lowest level of the index is stored on the same cylinders as the data.

Question

Quizplus · Accepted Answer

C) is incorrect because B+-tree indexes do not require every new record insertion to use an empty reserve track or cylinder. B+-trees can accommodate new entries through node splits and redistributions without necessarily needing reserved space.

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