nerdexam
Oracle

1Z0-082 · Question #77

You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is…

The correct answer is E. ROW STORE COMPRESS ADVANCED. You've hit your weekly limit · resets 5am (America/New_York)

Manage Storage

Question

You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is best suited for this?

Options

  • ACOLUMN STORE COMPRESS FOR QUERY LOW
  • BROW STORE COMPRESS BASIC
  • CCOLUMN STORE COMPRESS FOR ARCHIVE LOW
  • DCOLUMN STORE COMPRESS FOR ARCHIVE HIGH
  • EROW STORE COMPRESS ADVANCED

How the community answered

(32 responses)
  • A
    9% (3)
  • B
    3% (1)
  • D
    6% (2)
  • E
    81% (26)

Explanation

You've hit your weekly limit · resets 5am (America/New_York)

Topics

#table compression#OLTP compression#ROW STORE COMPRESS ADVANCED#DML compression

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice