Multiple choice technology programming languages

The DBWR process is NOT responsible for:

  1. Defers writes for I/O optimization

  2. Uses a LRU algorithm to keep most recently used blocks in memory

  3. Writes to database redo log files as people COMMIT data

  4. Writes all changed (i.e. dirty) buffers to datafiles
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DBWR does NOT write to redo log files - that's LGWR's job. DBWR writes dirty buffers from the buffer cache to datafiles. Option A describes correct DBWR behavior (defers writes for batching). Option B describes DBWR's LRU algorithm for cache management. Option D is DBWR's primary function. Writing to redo logs is exclusively LGWR's responsibility.

Keep practicing — related questions