Home
About us
Site map
Contact us
SQL Server blogs, articles, scripts and tips
Menu
Home
Articles
Tips
Blogs
Quiz
Scripts
Links
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.
Thanks for that !
SQL Quiz
This is the answer!
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.