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

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 is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?

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

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

Which of the following queries is used to rename a database in SQL Server 2008?

By default, SQL Server treats NULL as what data type

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

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

What does the EOMONTH function do?

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