What is a checkpoint in dbms and when does it occur?



What is a checkpoint in dbms and when does it occur?..

Answer / Dilshad Ahamad

A Checkpoint in DBMS is a point at which all the changes made to the database are written permanently to stable storage. It helps recover the database efficiently in case of system failures.nCheckpoints occur during system shutdown, manual checkpoint operations, or when a specific number of transactions have been processed.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

Why is databases important in healthcare?

1 Answers  


How do you copy a database?

1 Answers  


Which is the best free database software?

1 Answers  


Define transaction and transaction isolation levels?

1 Answers  


What are the types of database users?

1 Answers  


What are the features of dbms?

1 Answers  


Which is the most used database?

1 Answers  


What is database write application of database?

1 Answers  


How does a database partition work?

1 Answers  


What integrity rules exist in the dbms?

1 Answers  


What is the difference between delete and truncate command in dbms?

1 Answers  


What is the largest component of a database?

1 Answers  


Categories