- A To define a primary key for a table
- B To ensure data integrity
- C To optimize query performance
- D To enforce referential integrity
- Share this MCQ
Answer:
C
Share this MCQ
An index in a relational database is a data structure that improves the speed of data retrieval operations, such as searching, sorting, and joining tables. It allows the database engine to locate data more efficiently by creating a separate data structure based on selected columns.
Click me to Read more Question & Answer of Relational database conceptsShare this MCQ