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?

You should avoid the use of cursors because:

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

Which of the following statements are false?

Which of the following statements are true?

You want to display the titles of books that meet the following criteria: 1. Purchased before November 11, 2002 2. Price is less than $500 or greater than $900 You want to sort the result by the date of purchase, starting with the most recently bought book. Which of the following statements should you use?

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?

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 options is used to change the value of the password variable and exit using sqlcmd?

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

Which of the following statements is NOT true about the UNIQUE constraint of SQL Server 2008?