Which of the following standard reports will show you the fragmentation of the physical indexes?

Can a unique key with not null constraint make it a primary key?

Which of the following is not a valid string constant or hexadecimal constant?

What would be the output of following statement: Select * from tbl_Employee where Emp_Name=NULL

Which of the following is not a valid data type in SQL Server 2012?

What is a collection of zero or more continuous CircularString and/or LineString instances of either geometry or geography types called?

Analyze the following permissions: 1.ALTER permission on the database. 2.CONTROL permission in the database. 3.ALTER ANY SCHEMA permission and CREATE XML SCHEMA COLLECTION permission in the database. Which of the above permissions is/are required to create an XML SCHEMA COLLECTION?

A local temporary stored procedure name can contain a maximum of __________ characters

FILESTREAM storage is best used when the BLOB file sizes average 1MB or higher.

Which of the following statements using GROUP BY clause are allowed in SQL Server 2008?

Which of the following is used to comment a portion of an SQL Server 2008 script?