Sorting records are unlike indexing records in that:
A)Sorting physically rewrites records on disks whereas indexing does not
B)Sorting requires a primary key whereas indexing does not
C)Indexing requires a separate database file whereas sorting does not
D)none of these

Question

Quizplus · Accepted Answer

Sorting involves physically arranging records on disks based on some criteria, which requires rewriting the records in the new order. Indexing, on the other hand, creates a separate database file that contains pointers to the original records, without physically modifying their order. Choice B and C are incorrect as both sorting and indexing can be done with or without a primary key, and without requiring a separate file, respectively.

Sorting Records Are Unlike Indexing Records in That