Oracle Database 12c: Advanced Administration — Question 23

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 backing up in mount state allows the database to be accessed in a way that ensures only valid and formatted blocks are included in the backup. Option B is incorrect as the tablespace does not necessarily need to be offline for this type of backup. Option C is not relevant as it doesn't pertain to the requirement of including only formatted blocks. Option D is also incorrect since an image copy backup includes all blocks, not just the formatted ones.