Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.

Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?

Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?

Analyze the following code snippet: DECLARE @myDate DATETIME2 SELECT @myDate = '2009/10/08 12:35:29.2348 +12:15' SELECT @myDate AS '@myDate' What is the output of the above code?

Which of the following clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?

Which of the following roles is required to connect to a Central Management Server?

Which data extents are backed up by a differential database backup?

Which system database holds information on SQL Server Agent jobs?

What is the benefit of using the TRY_CAST() function?

How is FILESTREAM data stored?

With automatic conflict resolution in peer-to-peer replication, which update wins the conflict?