Indexes(Engineering > Computer Science And Engineering > Dbms Questions And Answers ) Questions and Answers
Explanation:-
Answer: Option B. -> Column storeColumn storeA database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes.
Explanation:-
Answer: Option C. -> CoveringCoveringA covered query is a query where all the columns in the query's result set are pulled from non-clustered indexes.
Explanation:-
Answer: Option C. -> It is used for pointing data rows containing key valuesIt is used for pointing data rows containing key valuesNonclustered indexes have a structure separate from the data rows. A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value.
Explanation:-
Answer: Option B. -> Clustered index is built by default on unique key columnsClustered index is built by default on unique key columnsNonclustered indexes have a structure separate from the data rows. A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value.