← Quiz: Database Recovery: all 10 questions
Quiz: Database Recovery · Question 5 of 10
What is the main benefit of a checkpoint?
What is the main benefit of a checkpoint?
- A.It makes transactions run faster
- B.It deletes old transactions
- C.It prevents deadlocks
- D.Recovery can start from the last checkpoint instead of the beginning of the log
Answer & explanation
Correct answer: Recovery can start from the last checkpoint instead of the beginning of the log
Changes committed before the checkpoint are already on disk.
Can you get the rest right without peeking?
Take the timed Quiz: Database Recovery quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →