Question Details

Detailed explanation and options for the selected question.

What is the function of the INDEX in a database table?

A. To improve query performance
B. To enforce data integrity
C. To remove duplicate rows
D. To define relationships between tables

Explanation:

INDEX improves query performance by speeding up data retrieval. It does not enforce integrity, remove duplicates, or define relationships.