What is the rule for using different types of compression on different partitions of a single table stored on an Exadata Storage Server?

Question

Options

• AAll partitions must either be compressed or uncompressed.
• BAll partitions must use either OLTP compression or Hybrid Columnar Compression.
• CAny partition can use any type of compression, regardless of the compression of other partitions.
• DYou cannot mix compression types among partitions of the same table.

• A
  11% (6)
• B
  4% (2)
• C
  80% (45)
• D
  5% (3)

Explanation

Note 2: Oracle supports enabling any type of table compression at the partition or sub- partition level. An OLTP application, therefore, can store historical data in partitions with Archive Compression, while active data remains in partitions with OLTP Table Compression.

No community discussion yet for this question.