What is 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.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the state of the processor, when a process is waiting for some event to occur? 20.08.08
If the process is waiting for something to occur, then the process, and not the processor, should be in the waiting state. The processor would be scheduled to...What is an asychronous write ? 03.04.08
It is a write to disk that may occur before or long after a commit. The write is controlled by the buffer manager....What is the difference between a while statement and a do statement? 29.05.07
A while statement checks at the beginning of a loop to see whether the next loop iteration should occur. A do statement checks at the end of a loop to see wheth...What is the benefit of wrapping database calls into MTS transactions? 19.04.07
Aborting the transaction will undo and changes that occur within that transaction. This removes the possibility of stranded, or partial data....What is Endurance Testing? 28.02.07
Checks for memory leaks or other problems that may occur with prolonged execution....What are different types of Transaction Isolation Levels? 26.11.06
The isolation level describes the degree to which the data being updated is visible to other transactions. This is important when two transactions are trying to...Should validation (did the user enter a real date) occur server-side or client-side? Why? 14.03.06
It should occur both at client-side and Server side.By using expression validator control with the specified expression ie.. the regular expression provides the...Should user input data validation occur server-side or client-side? Why? 14.03.06
All user input data validation should occur on the server at a minimum. Additionally, client-side validation can be performed where deemed appropriate and fea...What is Lossless join property? 11.03.06
It guarantees that the spurious tuple generation does not occur with respect to relation schemas after decomposition....What is the difference between a while statement and a do statement? 07.03.06
A while statement checks at the beginning of a loop to see whether the next loop iteration should occur. A do statement checks at the end of a loop to see wheth...