Multiple choice sql-server

The SQL server that you've manages crashed. The disk drives were not damaged but there was data that had not been written to some databases. Which transactions will be rolled forward in each database when his SQL server starts the automatic recovery proce

  1. All committed transactions that are in the transaction log

  2. All uncommitted transactions that are in the transaction log

  3. All committed transactions that are in the transaction log between the last checkpoint and the failure

  4. All committed transactions that are in the transaction log between the last two checkpoints
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL Server recovery rolls forward committed transactions from the transaction log since the last checkpoint, ensuring durability. Transactions before the last checkpoint were already written to data files. Uncommitted transactions (B) are rolled back, not forward. Option A is incorrect because transactions before the checkpoint are already on disk. Option D is incorrect - recovery uses the last checkpoint, not the interval between two checkpoints.

Keep practicing — related questions