Examine the code given below:

SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000

Which of the following statements is correct with regard to this code?

___________  is the highest level of a transaction isolation implemented by SQL Server.

Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005?

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?

How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?

Which of the following features of SQL Server 2008 evaluates servers for compliance with a set of predefined conditions and prevents making undesirable changes to servers?

Which of the following statements is true if you create a global temporary table in SQL Server 2008 and specify a FOREIGN KEY with the CREATE TABLE command?

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.