Multiple choice technology databases

What is true about COMPRESSED backups in Oracle 11g? Choose all that apply

  1. ZLIB compression gives better compression ratio in comparison to BZIP2 compression

  2. BZIP2 compression gives better compression ratio in comparison to ZLIB compression

  3. ZLIB compression consumes much lesser CPU in comparison to BZIP2 compression

  4. BZIP2 compression consumes much lesser CPU in comparison to ZLIB compression

  5. ZLIB compression comes with additional licensing cost. BZIP2 compression comes with no additional cost

  6. BZIP2 compression comes with additional licensing cost. ZLIB compression comes with no additional cost
Reveal answer Fill a bubble to check yourself
B,C,E Correct answer
Explanation

Oracle 11g offers ZLIB and BZIP2 compression for RMAN backups. BZIP2 provides better compression ratio but consumes more CPU. ZLIB is faster but compresses less. ZLIB is included in base licensing, while BZIP2 requires additional licensing cost for the Advanced Compression Option.

Keep practicing — related questions