Question

3
select the correct answer.
gina has created an employee database. she wants to index the employee joining date field. why would she do that?
a. to create a link to another table
b. to create a new record
c. to decrease the overall search time
d. to sort that field

Explanation:

Indexes in databases are used to speed up data retrieval. When a field is indexed, the database engine can quickly locate the relevant rows without having to scan the entire table. This directly leads to a decrease in search time.

• Option A: Creating a link to another table is typically done using relationships (like foreign keys), not indexing.
• Option B: Indexing is not related to creating new records. New records are added through insert operations.
• Option D: While sorting can be made more efficient with an index in some cases, the primary and most direct purpose of indexing a field is to decrease search time, not just for sorting. Sorting is a by - product in some scenarios but not the main reason.

Answer:

C. to decrease the overall search time