SQL Server 2000 - Technical MCQs

Q1:

With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?

A Differential recovery

B Full recovery

C Simple recovery

D Bulk-logged recovery

ANS:D - Bulk-logged recovery

No answer description is available. Let's discuss.