If your database is in archivelog mode, how can you force an archive?

A. Issue an alter database switch logfile command.

B. Issue an alter system switch logfile command.

C. Issue an alter system log_archive_start command.

D. There is no command to force an archive; they happen automatically.

Answer: (B) Issue an alter system switch logfile command.

Explanation:

When the database is in the archive log mode then, the issue in the alter system switch logfile command force the particular switch. It basically produce achieve redo log which is smaller in the size by the dedicated size of the parameter log buffer.

It also govern the particular size of the RAM (Random access memory) buffer by redo log. This command is basically faster to return in the program by the use of redo log.

On the other hand, all the options are incorrect as this command only alter the system and does not alter the database. Therefore, Option (B) is correct.