What amount of storage is required by a date variable in SQL Server 2008?

PRIMARY KEY constraint defaults to __________ index.

Which of the following is a valid code to change the index created on a column of a table to page compression?

Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?

Analyze the following command: -o 'C:\Folder\' Which of the following statements is true if a file with the file name specified in the above command already exists?

Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.

Which of the following statements regarding 'views' are incorrect?

Which of the following is not a relational operation?

What does DBCC stand for?

SQL Server will create a unique nonclustered index, by default, when a primary key is created.

Backup and restore history is stored in which database?