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

question 91

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.

---

Definitions:

Organisation

A structured arrangement of people and resources designed to achieve specific goals and objectives.

Multifunctional Viewpoints

Perspectives that incorporate insights and considerations from various disciplines and functions to address complex problems or opportunities.

Middle Managers

Oversee the work of large departments or divisions.

Management Development

The process by which managers learn and improve their skills not only to benefit themselves but also their employing organizations.