Which statement is true about Oracle compression?

The correct answer is B. A partitioned table can define the use of Advanced Compression or Hybrid Columnar. With the data collected by Heat Map, Oracle Database can automatically compress each partition of a table independently based on Heat Map data, implementing compression tiering. This compression tiering can use all forms of Oracle table compression, including: Advanced Row…

Smart Scan and Hybrid Columnar Compression

Question

Options

AA non-partitioned table can use Advanced Compression and Hybrid Columnar Compression
BA partitioned table can define the use of Advanced Compression or Hybrid Columnar
CHybrid Columnar Compression can be defined for a single column.
DA partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.

How the community answered

(26 responses)

A
8% (2)
B
77% (20)
C
4% (1)
D
12% (3)

Explanation

With the data collected by Heat Map, Oracle Database can automatically compress each partition of a table independently based on Heat Map data, implementing compression tiering. This compression tiering can use all forms of Oracle table compression, including: Advanced Row Compression and all levels of Hybrid Columnar Compression (HCC) if the underlying storage supports HCC. Oracle Database can also compress individual database blocks with Advanced Row Compr ession based on Heat Map data.

Topics

#Hybrid Columnar Compression#Advanced Compression#partitioned tables#compression types

Community Discussion

No community discussion yet for this question.

Full 1Z0-485 Practice