What is an index? A. A wizard that creates a functional database structure based on the user’s selections B. A widely recognized naming convention for database objects C. A sort order for records, which is identified in the table design D. A set of relationship rules that enforce defined database relationships

A wizard that creates a functional database structure based on the user's selections
A widely recognized naming convention for database objects
A sort order for records, which is identified in the table design
A set of relationship rules that enforce defined database relationships

The correct answer is C. A sort order for records, which is identified in the table design.

An index is a data structure that improves the speed of data retrieval operations on a database table. It is used to quickly locate data without having to search every row in the table. Indexes are created on columns that are frequently used in queries.

Option A is incorrect because a wizard is a tool that helps users create database objects.

Option B is incorrect because a naming convention is a set of rules for naming database objects.

Option D is incorrect because a set of relationship rules is a set of rules that define how data in one table is related to data in another table.