In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
A. Clustered
B. Column store
C. Non clustered
D. Row store
Answer:A
In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
A. Clustered B. Column store C. Non clustered D. Row store
Explanation: A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes.