Upgrade Oracle DBA 11g to Oracle Database 12c — Question 17

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

Answer options

• A. The backup must be performed in mount state.
• B. The tablespace must be taken offline.
• C. All files must be backed up as backup sets.
• D. The database must be backed up as an image copy.

Correct answer: A

Explanation

The correct answer is A because performing the backup in mount state allows for a consistent backup of the database while ensuring that only formatted blocks are included. Option B is incorrect as taking the tablespace offline is not a requirement for this type of backup. Option C is misleading since while files can be backed up as backup sets, this does not specifically address the requirement of backing up only formatted blocks. Option D is also incorrect because backing up as an image copy does not limit the backup to formatted blocks.