Question: What is the purpose of an index in a database?

Options:

1. To store data
2. To speed up data retrieval
3. To enforce data integrity
4. To manage user access

Correct Answer: To speed up data retrieval

Solution:

An index is used to speed up the retrieval of rows from a database table by providing a quick lookup mechanism.