Beginner
Database Management Systems
Q10 / 100
What is an index in a database?
Correct! Well done.
Incorrect.
The correct answer is B) A data structure that improves query speed by providing fast access paths to rows without scanning the entire table
B
Correct Answer
A data structure that improves query speed by providing fast access paths to rows without scanning the entire table
Explanation
Indexes (B-tree by default in most RDBMS) speed up WHERE, JOIN, and ORDER BY on indexed columns. They consume storage and slow down writes — add them for frequently queried columns.
Progress
10/100