Multiple choice technology databases

When LGWR process write redo log buffer to redo log files?

  1. Log buffer is one-third full

  2. Commit transaction

  3. every three seconds

  4. redo log file switch
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

The LGWR (Log Writer) process writes redo log buffer to redo log files when: (A) the log buffer is one-third full, (B) a transaction is committed (ensuring durability), and (C) every three seconds (timeout-based write). Option D (redo log file switch) triggers LGWR to write to the new log file but is not one of the standard conditions for writing to the current log file. These mechanisms ensure that redo information is regularly persisted for database recovery.

Keep practicing — related questions