Sorting and Indexing database records are similar in that:
A)Neither require underlying table records
B)Both require the user to first define data validation rules
C)Both reorganize the way record data appear in outputs
D)none of these

Question

Quizplus · Accepted Answer

Both sorting and indexing reorganize the way record data appear in outputs. Sorting reorders the records based on a specified field or criteria, while indexing creates a separate data structure that maps the values in a specific field to their corresponding records. Both techniques improve data access and efficiency. Choices A and B are incorrect because both sorting and indexing rely on the underlying table records, and data validation rules may not be necessary for either technique. Choice D is incorrect because there is a similarity between sorting and indexing.

Sorting and Indexing Database Records Are Similar in That