Which of the following options is used to change the value of the password variable and exit using sqlcmd?

How many audit action groups are available for a server in SQL Server 2008 to perform different actions on audit data?

Which of the following statements using GROUP BY clause are allowed in SQL Server 2008?Which of the following statements using GROUP BY clause are allowed in SQL Server 2008?

Which of the following rules must be followed for combining the result sets of two queries by using UNION?

Which of the following options are available for the DATA_COMPRESSION clause specified for a table in SQL Server 2008?

Which of the following data types are supported by SQL Server 2008?

How can you view the structure of a table named 'myTable' in SQL Server?

You should avoid the use of cursors because:

View the following Create statement: 1 Create table Pers 2(EmpNo Int not null, 3 EName Char not null, 4 Join Datetime not null, 5 Pay Smallmoney) Which line contains an error?

Which of the following is not a column property?

A production house needs a sale report where total sale of the day is more than $20,000. Which of the following query should be used?