Retrieving the records of a file in order based on a set of field values is referred to as _____.
A) immediate sequential retrieval
B) logical sequential retrieval
C) physical sequential retrieval
D) direct retrieval
E) indirect retrieval

Question

Quizplus · Accepted Answer

Logical sequential retrieval involves organizing records based on a certain set of field values and retrieving them in order based on that organization. Immediate sequential retrieval involves retrieving records as they are physically stored on the disk, while physical sequential retrieval involves retrieving records in the order they are physically stored on the disk regardless of their field values. Direct retrieval involves accessing a specific record based on its address or key value, while indirect retrieval involves accessing records through an index or pointer. Based on the given options, logical sequential retrieval is the best choice for retrieving records in order based on certain field values.

Retrieving the Records of a File in Order Based on a Set