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?

Which clause will be used to extract data from Tables A and B having a similar structure but no relation between themselves?

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?

Which versions of SQL Server support table partitioning?