What is a covering index?

Question

Select the correct covering index definition from the options below:

Answer 1

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

Answer 2

An index that provides information about the table structure.

Answer 3

An index that covers all columns of the table.

Answer 4

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

Answer 5

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

Answer 6

An index that synchronizes transactions in the database.

Answer 7

An index that ensures unique values in columns.

Answer 8

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

Practice