Examine the two SQL statements given below:

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC

What is true about them?

Which of the following are false for batches (batch commands)?

Which of the following are not date parts?

Which one of the following must be specified in every DELETE statement?

What does referential integrity (also called relational integrity) prevent? 

Which of the following is an invalid statement for manipulation of binary data?

Which of the following compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?

What is the data type of the parameter 'Audit_file_offset' of function 'fn_get_audit_file()' in SQL Server 2008?

Which of the following scripting options are available while creating a script using the shortcut menu from the Object Explorer in SQL Server 2008 Management Studio?

Analyze the following code using wild card characters of SQL Server 2008: SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO Which of the following values will be returned by the above code?

Which of the following methods can be specified for the lock escalation of a table in SQL Server 2008?