SQL Quiz

What type of backups are supported by SQL Server ?

A. Full

B. Incremental

C. Differential

D. Transaction Log

Select all that apply (at least one).

What is a copy-only backup ?

A. A backup which is independent of the sequence of conventional backups

B. A backup which creates a further copy of a backup, usually on a different drive

C. A backup which does not create a backup file, but tests the integrity of an existing backup file

D. A backup which truncates the transaction log

Select one.

Which of the following are valid system databases in SQL Server 2008 ?

A. master

B. msdb

C. model

D. Resource

Select all that apply.

True or False - "TRUNCATE TABLE" resets the counter for an identity value back to its seed value ? ?

A. True

B. False

Select one.

Under what circumstances will TRUNCATE TABLE fail ?

A. If the table is referenced by a foreign key constraint from another table

B. If the table participates in an indexed view

C. If the table is referenced by a stored procedure

D. If the table has a trigger

Select all that apply.

You can alert someone to the contents of this page by emailing them a link. All fields are required. Only one email address can be specified.
To name :	*
To email address :	* *
Personal message :	*

Your name :	*
Your email address :	* *
To prevent abuse please type the security code below into the box underneath.

Please enter the security code above :	*
You can view our privacy policy using the link at the bottom of each page.