SQL Interview Questions #152: What is a covering index?

SQL code copied to buffer

Group tasks by:

complexity

category

database

Task 152:

Select the correct covering index definition from the options below:

An index that determines the order in which queries are executed.

An index that provides access to data in a specific sequence.

An index that provides information about the table structure.

An index that covers all columns of the table.

An index that contains all the columns needed to run a query without accessing the table itself.

An index that synchronizes transactions in the database.

An index that ensures unique values in columns.

An index that ensures data integrity during changes in the table.

Mark all correct answers and click the "Check!" button

Login