Which term describes ordering records in a database by a specified sequence?

Which term describes ordering records in a database by a specified sequence?

• A. Filtering
• B. Sorting
• C. Grouping
• D. Indexing

Answer: (B)

Sorting is the act of arranging records according to a chosen key in a specified order, such as ascending or descending. This enables you to present data in a meaningful sequence, like sorting employees by last name or by hire date. Filtering would select a subset of records, while grouping would combine records for aggregate calculations. Indexing speeds up lookups but doesn’t by itself define the order of results unless you explicitly request an order with something like an ORDER BY clause.

Sorting is the act of arranging records according to a chosen key in a specified order, such as ascending or descending. This enables you to present data in a meaningful sequence, like sorting employees by last name or by hire date. Filtering would select a subset of records, while grouping would combine records for aggregate calculations. Indexing speeds up lookups but doesn’t by itself define the order of results unless you explicitly request an order with something like an ORDER BY clause.