All of the Following Are Advantages of the B+-Tree Index

question 103

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.

---

Definitions:

Carrying Capacity

The maximum population size of a species that an environment can sustain indefinitely, given the food, habitat, water, and other necessities available in the environment.

Logistic Equation

A mathematical model used to describe the growth of populations under limiting conditions, showing a sigmoid curve.

Aggregated Distribution

A pattern of population distribution where individuals are clustered together in groups.

Random Dispersion

The spatial distribution pattern of a population in which the presence of one individual has no effect on the distribution of other individuals. Compare with clumped dispersion and uniform dispersion.