Question

How we can force a log switch?

(a) By using ALTER SYSTEM LOG

(b) By using ALTER SYSTEM SWITCH LOGFILE

(c) By using ALTER SYSTEM SWITCH LOGS

(d) By using ALTER SYS LOGFILES

I had been asked this question during an interview.

My question is taken from Storing and Guarding the Data in chapter Oracle Database 11g Architecture Options of Oracle

Answer 1

Right answer is (b) By using ALTER SYSTEM SWITCH LOGFILE

Explanation: To force a log switch, you must have the ALTER SYSTEM privilege. Use the ALTER SYSTEM statement with the SWITCH LOGFILE clause.