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?

You have a database named 'marketnikkie', the backup of which is stored at 'D:\marketnikkie.bak' location on your server. Due to some electric fluctuations, the database gets corrupt. Which of the following is the correct query to restore your database?

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?

Which of the following best describes the flow for the execution of a CLR stored procedure?