Interview Questions
1. What is a check point?
A checkpoint is a point in time created by the checkpoint process at which SQL Server can be sure that any committed
transactions have had all their changes written to disk. This checkpoint then becomes the marker from which database
recovery can start. The checkpoint process ensures that any dirty pages associated with a committed transaction are flushed
to disk.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment