Each table in SQL Server 2008 can have up to ______ nonclustered indexes.

What is the maximum number of processors that can be used in parallel plan execution using the MAXDOP option in SQL Server 2008?

Which of the following options is NOT supported by the ON DELETE clause of a FOREIGN KEY constraint of SQL Server 2008?

Which of the following methods can be specified for the lock escalation of a table in SQL Server 2008?

Analyze the following code using wild card characters of SQL Server 2008: SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO Which of the following values will be returned by the above code?

Which of the following scripting options are available while creating a script using the shortcut menu from the Object Explorer in SQL Server 2008 Management Studio?

What happens if you type the following statement at the T-SQL prompt? SELECT getdate()

Which of the following are aggregate functions in SQL?

Which of the following is an invalid statement for manipulation of binary data?

What does referential integrity (also called relational integrity) prevent? 

Which one of the following must be specified in every DELETE statement?