Which statement is true about Oracle compression?
A.
A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.
B.
Hybrid Columnar Compression can be defined for a single column.
C.
A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.
D.
A partitioned table can define the use of Advanced Compression Hybrid Columnar Compression for each
partition.
C is right
Sorry It’s D. But the answer miss or
A partitioned table can define the use of Advanced Compression or Hybrid Columnar Compression for each partition.
C doesnt look right.
http://ora-x2.blogspot.de/2011/05/can-both-hcc-and-advanced-compression.html
D is right: A partitioned table can define the use of Advanced Compression OR Hybrid Columnar Compression for each
partition.
Note from Exadata Student guide: You can use Hybrid Columnar Compression on complete tables or in combination with basic and OLTP compression by using partitioning.