Multiple choice technology databases

Maximum no of non clustered index in a table.

  1. 192

  2. 255

  3. 249

  4. 300

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SQL Server 2005 and earlier versions, a table could have a maximum of 249 non-clustered indexes (along with 1 clustered index). While newer versions (SQL Server 2008 and later) expanded this limit to 999, 249 remains the correct historical limit among the choices, making other options incorrect.