How many clustered indexes can a single table have in SQL Server, and why?
Correct answer D. One, because the clustered index defines the physical order of the data rows
Explanation
A clustered index sorts and stores the table's data rows themselves in key order, and rows can be physically ordered in only one way, so a table can have just one. Non-clustered indexes are separate structures holding key values and row locators, so a table can have many of them. Declaring a primary key creates a clustered index automatically if the table does not already have one.
Answer checked How we write and check questions
Discussion