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 of the following spatial data types are used in SQL Server 2008?

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?

Which of the following options is correct about identity(seed, increment)?