Which of the following security features have been introduced in SQL Server 2008?

Which of the following encryption algorithms are used by the Transparent Data Encryption security mechanism of SQL Server 2008?

Which of the following formats are supported by the language_term argument while altering a full-text stoplist in SQL Server 2008?

Which of the following are valid DATETIME functions in SQL Server 2008?

Which of the following counters are used to monitor compression of the whole instance of SQL Server?

Which of the following statements are true about the FILESTREAM argument of SQL Server 2008?

Which one of the following fields is the ideal candidate for the primary key in a student record base? 

Is the FROM clause necessary in every SELECT statement?

Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in descending order of the CurrentStock column.

Which operator will be evaluated first in the following statement:

select (age + 3 * 4 / 2 - 8) from emp

What is the maximum value that can be stored for a datetime field?