Which of the following commands is used to start the Resource Governor in SQL Server 2008?

In which of the following statements can TOP clause be used in SQL Server 2008?

Suppose e1 and e2 denote two decimal expressions with precisions p1 and p2 and scales s1 and s2, respectively. What is the result precision of the following operation on the two expressions?

Which of the following operators will be evaluated first in the following statement? Select (salary+40^2*30/5) from employees

State whether True or False. The 'text' and 'ntext' data type can store character based data. These data types can be used in joins

Which of the following is not a type of Database backup in the SQL SERVER 2005?

The LAG analytic function is used in a ______ statement to compare values in the current row with values in a previous row.

Which of the following stores FileStream data?

You are querying a table that contains a field with the data type XML and need only rows that have a particular value in the XML data. Which of the following would not result in an error

True or false? Intersection tables should have an autoincrement column as the primary index

Which of the following relationships requires a reference table?