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?

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

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

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

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

What does CTE stand for?

A table can have more than one primary key.

A stored procedure can recursively call itself.

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