Multiple choice technology databases

Identify the background process which, is responsible for writing data from buffer cache to the datafiles to make changes permanent

  1. Checkpoint (CKPT)

  2. Database Writer (DBWR)

  3. Process Monitor (PMON)

  4. Log Writer (LGWR)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Database Writer (DBWR) is responsible for writing modified data from the buffer cache to the actual datafiles on disk. This makes changes permanent and ensures durability. DBWR operates asynchronously and uses sophisticated algorithms to optimize write performance. CKPT coordinates checkpoints, PMON handles process cleanup, LGWR writes to redo logs - only DBWR writes to datafiles.

Keep practicing — related questions