Explanation:Locks are used to maintain database consistency. 3. Which of the following are introduced to reduce the overheads caused by the log-based recovery?
A. Checkpoints
B. Indices
C. Deadlocks
D. Locks
Answer:A
Explanation:Locks are used to maintain database consistency. 3. Which of the following are introduced to reduce the overheads caused by the log-based recovery?
A. Checkpoints B. Indices C. Deadlocks D. Locks
Explanation:Checkpoints are introduced to reduce overheads caused by the log-based recovery. 4. Which of the following protocols ensures conflict serializability and safety from deadlocks?