You want to back up a database such that only formatted blocks are backed up. Which
statement is true about this backup operation?
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.
The correct answer is C.
C
C
C
A,–>backup performed during mount state will include empty(formatted) blocks.
Unused block compression (new in 10g, before was NULL block compression – above HWM)
Unused block compression is turned on automatically when all of the following five conditions are true:
*The COMPATIBLE initialization parameter is set to 10.2 or higher.
*There are currently no guaranteed restore points defined for the database.
*The data file is locally managed.
*The data file is being backed up to a backup set as part of a full backup or a level 0 incremental backup.
*The backup set is created on disk, or Oracle Secure Backup is the media manager.
C
C