What are database checkpoints?


Database checkpoints are operations in which the DBMS writes all of its updated buffers to disk. While this is happening, the DBMS does not execute any other requests. A checkpoint operation is also registered in the transaction log. As a result of this operation, the physical database and the transaction log will be in sync. This synchronization is required because update operations update the copy of the data in the buffers and not in the physical database. Checkpoints are automatically scheduled by the DBMS several times per hour. Checkpoints also play an important role in transaction recovery

Business

You might also like to view...

List the major objectives of events and experiences as promotion tools

What will be an ideal response?

Business

When ______, an organization must first consider the supply and demand factors in a particular category of jobs.

A. recruiting B. retraining C. forecasting D. training

Business

How well services meet customer expectations is called ____.

A. effectiveness B. efficiency C. quality D. customer satisfaction

Business

_______ is the formal and informal sharing of meaningful and timely information between firms

a. Customer selection b. Ordering selection c. Communication d. Continuity

Business