Which of the following is a database object that physically stores all columns that are needed to query a single table?
A)foreign key table
B)primary key table
C)covering index
D)composite index

Question

Quizplus · Accepted Answer

A covering index is a database object that physically stores all columns that are needed to query a single table. This index includes all of the columns that are required in the SELECT, WHERE, and ORDER BY clauses of a query, which allows the database to use the index to satisfy the query without accessing the data in the table itself. Foreign key tables and primary key tables are used to enforce referential integrity and are not related to storing columns for querying a single table. A composite index is an index that includes multiple columns, but it may not necessarily include all of the columns required for a query.

Which of the Following Is a Database Object That Physically