Multiple choice technology databases

Which action will cause a log switch?

  1. A transaction completes.

  2. The instance is started.

  3. The instance is shut down

  4. The current online redo log group is filled
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Oracle databases, a log switch occurs when the current online redo log group becomes full and LGWR needs to continue writing. Oracle then switches to the next available redo log group. This is a normal, automatic operation that happens continuously during database operation. Transaction completion, instance startup, or shutdown do not directly cause log switches.

Keep practicing — related questions