Maximum no of non clustered index in a table.
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.