Multiple choice

How to force a log switch?

  1. By using ALTER SYSTEM LOG

  2. By using ALTER SYSTEM SWITCH LOGFILE

  3. By using ALTER SYSTEM SWITCH LOGS

  4. By using ALTER SYS LOGFILES
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The ALTER SYSTEM SWITCH LOGFILE command forces an immediate log switch, causing LGWR to stop writing to the current online redo log group and switch to the next group. This is useful for forcing checkpoints or manually managing log file rotation.

Keep practicing — related questions