Multiple choice technology programming languages

Which statement about the LGWR is false?

  1. There is only one redo log writer per instance

  2. A commit confirmation may be issued before a transaction has been recorded in the redo log file

  3. During long transactions Oracle can flush data to the redo logs before it is committed

  4. An Oracle instance cannot survive without a redo log writer
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Option B is false: Oracle guarantees commit confirmation ONLY after the transaction is written to the redo log file. This is fundamental to ACID durability. Options A, C, D are true: one LGWR per instance, long transactions can flush pre-commit (still written), and LGWR is essential for instance survival.

Keep practicing — related questions