All of the following are characteristics of an indexed computer file and its index, except _____.
A) the records of the file are sorted into the same order as the values in the index
B) a set of field values is copied from the file into the index
C) the field values copied into the index are sorted in the index
D) the field values in the index are associated with the location of the records in the file from which they were copied
E) the index consists of two columns, one for the field values copied from the file and one for the pointers back to the records of the file.

Question

Quizplus · Accepted Answer

All of the other choices (B, C, D, E) describe characteristics of an indexed computer file and its index. However, choice A is incorrect because the records of the file do not necessarily have to be sorted into the same order as the values in the index. Instead, the index can be used to locate specific records in the file quickly, regardless of their original order.

All of the Following Are Characteristics of an Indexed Computer