SQL Quiz

What type of backups are supported by SQL Server ?





Select all that apply (at least one).



What is a copy-only backup ?





Select one.



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





Select all that apply.



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



Select one.



Under what circumstances will TRUNCATE TABLE fail ?





Select all that apply.