Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?

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 statements are false?

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?