Multiple choice technology databases

How many clustered and non clustered indexex exists for single table

  1. 1,10

  2. 10,10

  3. 1,249

  4. 249,1
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL Server allows exactly 1 clustered index per table because the clustered index determines the physical order of data storage. A table can have up to 999 non-clustered indexes (older documentation mentioned 249 as a practical limit). Option C correctly shows 1 clustered and 249 non-clustered indexes. The other options show incorrect combinations.

Keep practicing — related questions