A database manager would like to reduce the overhead caused by log-based recoveries. Which of the following should the manager use to best mitigate the situation?

The correct answer is B. Checkpoints. Checkpoints reduce log-based recovery overhead by periodically saving a snapshot of the database's current state to disk, so during recovery the system only needs to replay log entries from the last checkpoint forward - not the entire log history. Deadlocks (A) are a concurrency

Database Management and Maintenance

Question

Options

ADeadlocks
BCheckpoints
CLocks
DIndexes

How the community answered

(20 responses)

A
5% (1)
B
75% (15)
C
15% (3)
D
5% (1)

Explanation

Checkpoints reduce log-based recovery overhead by periodically saving a snapshot of the database's current state to disk, so during recovery the system only needs to replay log entries from the last checkpoint forward - not the entire log history. Deadlocks (A) are a concurrency problem where transactions block each other indefinitely; they have nothing to do with recovery efficiency. Locks (C) control concurrent access to data and prevent conflicts, but they don't affect how much work a recovery process must do. Indexes (D) speed up query lookups but play no role in the recovery mechanism at all.

Memory tip: Think of a checkpoint like a "save game" in a video game - when you restart after a crash, you reload from the last save point rather than replaying everything from the beginning.

Topics

#Checkpoints#Log-based Recovery#Recovery Optimization#Database Maintenance

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice