⟩ Explain a checkpoint and When does it occur?
A Checkpoint is like a snapshot of the DBMS state. By taking checkpoints, the DBMS can reduce the amount of work to be done during restart in the event of subsequent crashes.
Question and Answer:
Home Database Hierarchical
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
When DB2 connection fails, will online program work or give errors?
Can you have more than one cursor open at any one time in a program ?
How does DB2 determine what lock-size to use?
What is a composite index and how does it differ from a multiple index?
What are delete-connected tables?
What are the disadvantages of PAGE level lock?
What is a precompiler?
What is the diff bet plan,package,dbrm?
Give the COBOL definition of a VARCHAR field.
When can an insert of a new primary key value threaten referential integrity?
