The SETCERT.EXE utility can be used to do what?

What does the EOMONTH function do?

Can you select the built in Server Roles for SQL Server from the list below?

When retrieving data, which command may be used to rotate a set of column names from horizontal across the top to vertically, appearing as values among the result set

By default, SQL Server treats NULL as what data type

True or false? Foreign keys always point to other tables.

The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of __________ return type.

What should a computed column be marked as so that SQL Server Database Engine can physically store values in a table?

Which of the following is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?

Analyze the following data types and schemas: 1.The SQL Server system data type. 2.The default schema of the current user in the current database. 3.The dbo schema in the current database. In which order does the SQL Server Database Engine refer to type_name when a type_schema_name is NOT specified while creating a table in SQL Server 2008?

Which of the following code snippets causes only partition number 1 to be rebuilt while changing the compression of a partitioned table?