Medium-Easy Understand Database Design Multiple Choice

What is a covering index and how does it improve query performance?

Understand — Tests comprehension and ability to explain concepts.

Answer Options

A An index that covers all tables in the database

B An index containing all columns needed by a query, eliminating table access

C An index that automatically updates when data changes

D An 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).

Learn Database Design → Browse All Questions

More Database Design Questions

What does ACID stand for?

Which type of index is best for a query with a range condition like WHERE age BETWEEN 20 AND 30?

The left-prefix rule for composite indexes means a composite index on (a, b, c) can serve a query filtering only on column b.

What is denormalization and when is it appropriate?

True or False: A foreign key constraint automatically creates an index on the referencing column.