Multiple choice technology databases

Which of the following sentences is true for recovery models?

  1. In the Simple recovery model, all transactions are logged.

  2. In the Bulk-Logged recovery model, all transactions are logged.

  3. In the Full recovery model, most transactions are minimally logged.

  4. In the Simple recovery model, most transactions are minimally logged.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In the Simple recovery model, minimal logging is used for most transactions to save space and improve performance; the log is automatically truncated. Bulk-Logged minimally logs bulk operations but fully logs other transactions. Full recovery logs all transactions. Therefore, the correct statement is that in Simple recovery, most transactions are minimally logged, which conserves log space.

Keep practicing — related questions