Oracle Database 12c: Installation and Administration — Question 225

You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)

Answer options

• A. The backups would be consistent.
• B. The backups would be possible only if the database is running in ARCHIVELOG mode.
• C. The backups need to be restored and the database has to be recovered in case of a media failure.
• D. The backups would be inconsistent.
• E. The backups by default consist of all the data blocks within the chosen files or the full database.

Correct answer: B, C, D

Explanation

The correct answers are B, C, and D. Backups in Oracle Database 12c require the database to be in ARCHIVELOG mode (B) for recovery purposes. In the event of a media failure, the backups must be restored and the database recovered (C). Since the database is open and not in a consistent state, the backups would be inconsistent (D). Options A and E are incorrect as they do not accurately reflect the nature of backups in this scenario.