Database Management Systems (DBMS)
Identify the correct definition of Database index.
- A. A database structure that improves the speed of data retrieval operations on a table. ✓
- B. A stored procedure that automatically executes in response to certain events on a table.
- C. The process of intentionally introducing redundancy into a database to improve read performance.
- D. An SQL operation that combines rows from two or more tables based on a related column.
Correct answer
A. A database structure that improves the speed of data retrieval operations on a table.
Explanation
Database index refers to a database structure that improves the speed of data retrieval operations on a table.