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

In database mirroring, an instance can be a mirror in some mirroring sessions and a witness in other mirroring sessions.

A stored procedure can recursively call itself.

A table can have more than one primary key.

What does CTE stand for?

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

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

What is the maximum number of columns that can be combined into a single composite index key?

Which of the following data types can be specified as SPARSE?

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

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