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?

What range is supported by the TIME data type in SQL Server 2008?

Which of the following is a valid syntax of the ALTER SERVER AUDIT statement used to enable a server audit?

What is the name of the default instance installed by SQL Server 2008 Express in your computer?

How is FILESTREAM data stored?

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

What does the ROLLBACK TRANSACTION statement do?

Which clause allows you to filter the result of a column that has been aggregated?

What does CTE stand for?