Oracle Database 12c: Advanced Administration — Question 146

Which three statements are true about compression of backup sets?

Answer options

• A. Compressed backups can only be written to media.
• B. Binary compression creates performance overhead during a backup operation.
• C. Unused blocks below the high-water mark are not backed up.
• D. Compressed backups cannot have section size defined during a backup operation
• E. It works only for locally managed tablespaces.

Correct answer: B, C, E

Explanation

Option B is correct because binary compression does introduce performance overhead as it requires additional processing. Option C is accurate since unused blocks below the high-water mark are excluded from backups, optimizing storage. Option E is also true, as compression is limited to locally managed tablespaces, while the other options either misrepresent the functionality or are incorrect.