SQL Server 2000 – True or False

11. READ COMMITTED is the default isolation level.

A. True
B. False

Show Answer

12. A differential backup makes a copy of the entire database.

A. True
B. False

Show Answer

13. SQL Server supports three recovery modes: simple, full and Bulk.

A. True
B. False

Show Answer

14. SERIALIZABLE is the strictest isolation level.

A. True
B. False

Show Answer

15. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

A. True
B. False

Show Answer