nerdexam
Oracle

1Z0-485 · Question #15

When should you use Hybrid Columnar Compression?

The correct answer is C. on tables or partitions that have fairly static data. It is recommended that HCC be enabled on tables or partitions with no or infrequent DML

Smart Scan and Hybrid Columnar Compression

Question

When should you use Hybrid Columnar Compression?

Options

  • Aalways
  • Bon large active tables where deeper compression is desired
  • Con tables or partitions that have fairly static data
  • Don every table where Advanced Compression is not used

How the community answered

(27 responses)
  • A
    15% (4)
  • B
    4% (1)
  • C
    70% (19)
  • D
    11% (3)

Explanation

It is recommended that HCC be enabled on tables or partitions with no or infrequent DML

Topics

#Hybrid Columnar Compression#static data#compression use cases#HCC

Community Discussion

No community discussion yet for this question.

Full 1Z0-485 Practice