Question

What happens to the data rows in a table when the table contains a clustered index?

a. Rows are sorted based on a specified column
b. Rows are removed permanently
c. Rows are duplicated for redundancy
d. Rows are grouped based on their primary key values

Answer 1

When a table contains a clustered index, the data rows are sorted based on a specified column. Option A is the answer.

Step-by-step explanation:

A clustered index determines the physical order of data rows in a table based on the specified column(s). In the case of option A, rows are sorted according to the column specified in the clustered index. This sorting facilitates quicker data retrieval when querying based on that column. It's essential to note that a table can have only one clustered index, and the decision on which column to use for clustering depends on the nature of the queries performed on the table. Options B, C, and D do not accurately describe the impact of a clustered index on the arrangement of data rows in a table.

Option A is the answer.