select the correct answer. gina has created a banking database. she wants to index the account opened date…

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

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

Answer

Brief Explanations:

Indexing a field in a database is mainly used to speed - up data retrieval. By creating an index on the Account Opened Date field, the database can quickly locate relevant records when querying based on this date, thus reducing the overall search time. Creating a new record is not related to indexing. Sorting is a different operation from indexing, and creating a link to another table is typically done through foreign keys, not indexing a single field for this purpose.

Answer:

B. to decrease the overall search time