A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
A. Clustered
B. Non Clustered
C. Covering
D. B-Tree
Answer:A
A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
A. Clustered B. Non Clustered C. Covering D. B-Tree
Explanation: A covered query is a query where all the columns in the query’s result set are pulled from non-clustered indexes.