SQL Server Interview Questions and Answers : Series 7

Question: How many columns can be used with roll up or with cube command?

Answer: 10 columns

Question: How many clustered index can be created on the table?

Answer: Only one clustered index can be created.

Question: How many columns can be selected in a select statement?

Answer: 4096 columns can be selected.

Question: How many columns can be selected in an insert statement?

Answer: 4096 columns can be inserted in an insert statement.

Question: What level of nesting is possible for stored procedure?

Answer: 32 levels on nesting is possible for SP.

Question: What level of nesting is possible for sub Queries?

Answer: 32 level of nesting.

Question: What level of nesting is possible for Triggers?

Answer: 32 level of nesting.

Question: How many non-clustered indexes can be created on a table?

Answer: 999 non clustered indexes can be created on table.

Question: How many parameters can be provided to a stored procedure?

Answer: 2100 parameters can be provided to a sp.

Question: How many parameters can be provided to a UDF?

Answer: 2100 parameters can be provided to an udf.

Question: How many columns can be taken in update statement?

Answer: 4096 columns can be updated in an update statement.


GO BACK TO MAIN QUESTIONS LIST