Oracle Database Administration II — Question 136

Which two are true about backup set compression using RMAN default compression? (Choose two.)

Answer options

• A. Compressed backups can be written only to media.
• B. Binary compression adds CPU overhead to backup operations.
• C. Unused blocks below the high water mark are backed up.
• D. Compressed backups cannot have a section size defined.
• E. Compression can be done only for locally managed tablespaces.

Correct answer: B, E

Explanation

Option B is correct because binary compression does indeed require additional CPU resources, which can slow down backup operations. Option E is also correct as RMAN default compression is applicable solely to locally managed tablespaces. The other options either misrepresent how backups function or do not accurately describe the limitations of RMAN's compression capabilities.