-Which of the Following Is True Regarding the Course File

question 125

Multiple Choice

$\begin{array}{lllll}\begin{array}{lll}\text { Course } \quad\quad \text { Record }\\\text { Name } \quad \quad \text { Address }\\\begin{array}{|l|l|}\hline \text { Anatomy } & 2 \\\hline \text { Biology I } & 1 \\\hline \text { Calculus I } & 4 \\\hline \text { Shakespeare } & 3 \\\hline \text { Statistics II } & 5 \\\hline\end{array}\\\text { Index }\end{array}&\begin{array}{lllll}\text { Record }&\text { Course\quad\quad\quad Course\quad\quad\quad\quad Number of\quad Professor }\\\text { Number }&\text { Number\quad\quad\quad Name\quad\quad\quad\quad Credits\quad\quad in Charge }\\\begin{array}{lr}1\\2\\3\\4\\5\end{array}&\begin{array}{|l|l|l|l|}\hline \text { BIOL1001 } & \text { Biology I } & 4 \quad\quad\quad& \text { Smith } \\\hline \text { BIOL3020 } & \text { Anatomy } & 3 & \text { Jones } \\\hline \text { ENGL2540 } & \text { Shakespeare } & 3 & \text { Duncan } \\\hline \text { MATH2000 } & \text { Calculus I } & 4 & \text { Stevens } \\\hline \text { MATH3500 } & \text { Statistics II } & 3 & \text { Jones } \\\hline\end{array}\\\end{array}\end{array}$
-Which of the following is true regarding the Course file and its index?

• A) The index shown is the only index that can be built over this file.
• B) The Professor in Charge field cannot be indexed because it is not unique.
• C) Because the Course Name field is indexed, the Course file should be sorted so that it is in order by Course Name.
• D) The Number of Credits field cannot be indexed because it has only two values.
• E) The Course Name field in the index must be in sorted order.

---

Definitions:

Mechanics' Lien

A legal claim against a property by construction workers, contractors, or suppliers for unpaid labor or materials.

Pennsylvania System

A penal system, also known as the separate system, developed in the 19th century, focusing on solitary confinement and individual penance as a form of rehabilitation.

General Contractor

A principal contractor who is responsible for the oversight of a construction project, managing subcontractors, and the coordination of the work on site.

Deed of Trust

A legal document that secures a real estate transaction by transferring the title of the property to a trustee until a loan is paid in full.