SQL Server 2000 – True or False

11. READ COMMITTED is the default isolation level.

A. True
B. False

Correct Answer:  A. True

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

A. True
B. False

Correct Answer:  B. False

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

A. True
B. False

Correct Answer:  A. True

14. SERIALIZABLE is the strictest isolation level.

A. True
B. False

Correct Answer:  A. True

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

A. True
B. False

Correct Answer:  B. False

Leave A Comment?

seven + thirteen =