Medium-EasyUnderstandDatabase DesignMultiple Choice
What is a covering index and how does it improve query performance?
Understand — Tests comprehension and ability to explain concepts.
Answer Options
AAn index that covers all tables in the database
BAn index containing all columns needed by a query, eliminating table access
CAn index that automatically updates when data changes
DAn index that spans multiple databases
Want to see the correct answer?
Get the answer with a detailed explanation, plus practice 21+ more Database Design questions with adaptive quizzes and timed interviews.
See the Answer on Guru Sishya →This question is from the Database Design topic (System Design).
More Database Design Questions
What does ACID stand for?
EasyWhich type of index is best for a query with a range condition like WHERE age BETWEEN 20 AND 30?
Medium-EasyThe left-prefix rule for composite indexes means a composite index on (a, b, c) can serve a query filtering only on column b.
Medium-EasyWhat is denormalization and when is it appropriate?
Medium-EasyTrue or False: A foreign key constraint automatically creates an index on the referencing column.
Medium-Easy