Assume that the records of the Airplane file are physically stored in the order shown.
a. Retrieve all of the records of the file physically sequentially.
b. Retrieve all of the records of the file logically sequentially based on the Manufacturer field.
c. Retrieve all of the records of the file logically sequentially based on the Airplane Number field.
d. Retrieve all of the records of the file logically sequentially based on the Year Built field.
e. Perform a direct retrieval of the records with an Airplane Number field value of 22663.
f. Perform a direct retrieval of the records with a Manufacturer field value of Boeing.

Question

Quizplus · Accepted Answer

The Answer of Assume that the records of the Airplane file are physically stored in the order shown.
a. Retrieve all of the records of the file physically sequentially.
b. Retrieve all of the records of the file logically sequentially based on the Manufacturer field.
c. Retrieve all of the records of the file logically sequentially based on the Airplane Number field.
d. Retrieve all of the records of the file logically sequentially based on the Year Built field.
e. Perform a direct retrieval of the records with an Airplane Number field value of 22663.
f. Perform a direct retrieval of the records with a Manufacturer field value of Boeing.

Assume That the Records of the Airplane File Are Physically