Multiple choice technology databases

Which process kicks in DBWR process?

  1. LGWR

  2. DBWR

  3. CKPT

  4. ARCH
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The CKPT (Checkpoint) process triggers the DBWR (Database Writer) process to write dirty buffers from the buffer cache to data files. This happens during checkpoint operations to ensure data consistency and reduce recovery time. LGWR (A) writes redo logs, DBWR (B) is the process being triggered, and ARCH (D) handles archiving of redo logs.

Keep practicing — related questions