Which of the following options is not correct about the DATEDIFF() function?

Consider the following statements and pick the correct answer: 1. ceiling() - returns the smallest integer greater than or equal to the specified value 2. floor() - returns the largest integer less than or equal to the specified value

In which sequence are queries and sub-queries executed by the SQL Engine?

The simplest query must include at least ________ and _________.

Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set

A table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: Select distinct(department) from employees

Which of the following evaluation modes of Policy-Based Management CANNOT be automated in SQL Server 2008?

The regular identifiers of SQL Server 2008 may contain a range of _____________ characters.

What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?

Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?

Analyze the following code snippet: DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01' SELECT @myTime AS '@myTime' What is the output of the above code?