___________  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?

The simplest query must include at least ________ and _________.

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.

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?