What is the benefit of using the TRY_CAST() function?

Which system database holds information on SQL Server Agent jobs?

Which data extents are backed up by a differential database backup?

Backup and restore history is stored in which database?

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

What does DBCC stand for?

Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?

Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?

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.

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?

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