What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?

Which of the following features is used by SQL Server Audit to create and manage audits in SQL Server 2008?

What is the default maximum precision of decimal data type in SQL Server 2008?

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?

Consider the transaction: Begin Transaction Create table A ( x smallint , y smallint ) Create table B ( p smallint , q smallint ) Update A set x=600 where y > 700 Update B set p=78 where q=99 If @@ error != 0 Begin RollBack Transaction Return End Commit Transaction Select the correct option:

What does BLOB stand for?

Which of the following statements is not true about the table object in SQL Server?

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

Which of the following are aggregate functions in SQL?