Oracle Service Cloud Developer — Question 3

Which statement is true about Hybrid Columnar Compression (HCC)?

Answer options

• A. HCC is a good choice for LOBs, BLOBs, and CLOBs.
• B. HCC data resides compressed in flash.
• C. HCC being a database feature will work with all types of storage hardware.
• D. HCC is best suited for OLTP type databases with a large number of ongoing transactions.

Correct answer: C

Explanation

The correct answer is C because HCC is designed to function with various types of storage hardware, making it versatile. Options A and D are incorrect as HCC is not specifically optimized for LOBs, BLOBs, CLOBs, or OLTP environments. Option B is misleading since HCC is not limited to flash storage.