Oracle Service Cloud Developer — Question 28

Which statement is true about Oracle compression?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer, A, is accurate because a partitioned table must choose between Advanced Compression and Hybrid Columnar Compression, not both at once. Option B is incorrect as Hybrid Columnar Compression is applied at the segment level, not the individual column level. Option C is wrong because a non-partitioned table can only use one type of compression at a time. Option D is misleading as it suggests the possibility of using both compressions concurrently within partitions, which is not allowed.