Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?

Which of the following is the correct order of steps to be followed while using the Transparent Data Encryption security feature of SQL Server 2008?

Which of the following commands is used to connect to a named instance of SQL Server using the sqlcmd utility of SQL Server?

Which of the following commands is used to run a Transact-SQL script file by using sqlcmd?

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

Which of the following permissions is required to drop a stored procedure in SQL Server 2008?

What are the three Transact-SQL statements that are related to authorization?

In SQL Server 2012 and later versions, the sysadmin password requires at least 8 characters and which of the following character types?

Which constraint type specifies that a column contains column values from another table?

A member of the sysadmin role is allowed to perform which actions?

What is the order of precedence of ORDER BY and GROUP BY?