Question

State true or false: Using checkpoints reduces overhead

(a) True

(b) False

This question was posed to me at a job interview.

This intriguing question originated from Recovery and Atomicity topic in division Recovery System of RDBMS

Answer 1

Correct answer is (a) True

To explain I would say: Using checkpoints reduces overhead because the search process is time consuming and searching for transactions does not take place if we use checkpoints.