Oracle Database 12c: Installation and Administration — Question 67

Which statement is true about the Log Writer process?

Answer options

• A. It writes when it receives a signal from the checkpoint process (CKPT).
• B. It writes concurrently to all members of multiplexed redo log groups.
• C. It writes after the Database Writer process writes dirty buffers to disk.
• D. It writes when a user commits a transaction.

Correct answer: D

Explanation

The correct answer is D because the Log Writer process is triggered to write when a transaction is committed by a user, ensuring that the changes are recorded in the redo log. Option A is incorrect as the Log Writer does not wait for a signal from the CKPT process to write. Option B is misleading because while it can write to multiplexed groups, it does not necessarily do so concurrently. Option C is false since the Log Writer operates independently of the Database Writer's actions.