Oracle Database 12c: Installation and Administration — Question 97

Which statement is true about a database in ARCHIVELOG mode?

Answer options

• A. All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.
• B. Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
• C. A Fast Recovery Area (FRA) must be configured for the database.
• D. Full database backups can be performed when the database is opened.

Correct answer: D

Explanation

The correct answer is D because in ARCHIVELOG mode, full database backups can indeed be taken while the database is open and operational. Option A is incorrect because backups taken before switching to ARCHIVELOG mode cannot be used for complete recovery if the database needs it. Option B is not necessary as multiplexing redo logs is not a prerequisite for enabling ARCHIVELOG mode. Option C is misleading since configuring a Fast Recovery Area is not mandatory to operate in ARCHIVELOG mode.