Which of the following is true about indexes, in general?
A) An index can only be built over a field that has unique values.
B) Only one field of a file can be indexed.
C) An index can be used to retrieve the records of a file in logical sequence based on the indexed field.
D) An index cannot be built over a combination of fields of a file.
E) The updating of an indexed field in a record requires that the index be updated but record insertions and record deletions do not require any index to be updated.

Question

Quizplus · Accepted Answer

An index can be used to retrieve the records of a file in logical sequence based on the indexed field. This is one of the main purposes of an index.

Options A, B, D, and E are not true about indexes in general. An index can be built over a field that has duplicate values (but it may not be as effective), multiple fields of a file can be indexed, an index can be built over a combination of fields of a file, and updating and inserting/deleting records may require the index to be updated.

Which of the Following Is True About Indexes, in General