Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q86: A new primary key attribute can be
Q87: A fixed disk has 100 cylinders. The
Q88: Using the division remainder algorithm for a
Q89: Consider Table A on the "one side"
Q90: In vertical partitioning, each partition must have
Q92: Storing repeating groups within a single table
Q93: Denormalization is a physical design technique that
Q94: In an indexed-sequential file, an index is
Q95: Consider the following relational database for
Q96: A file with a B+-tree index is