1Z0-082 practice question 16 of 25

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

Full set: 142 questions
Answer options
A: COLUMN STORE COMPRESS FOR QUERY LOW
B: ROW STORE COMPRESS BASIC
C: COLUMN STORE COMPRESS FOR ARCHIVE LOW
D: COLUMN STORE COMPRESS FOR ARCHIVE HIGH
E: ROW STORE COMPRESS ADVANCED Correct answer
Correct Answer:
E. ROW STORE COMPRESS ADVANCED
Explanation

For an Online Transaction Processing (OLTP) environment, Advanced Row Compression (ROW STORE COMPRESS ADVANCED) is the most suitable option. It is specifically designed to compress data for all DML operations (INSERT, UPDATE, DELETE), not just bulk loads. This feature, part of the Advanced Compression option, minimizes performance overhead on DML, making it ideal for active transactional tables where both space savings and performance are critical. It avoids the significant DML penalties associated with Hybrid Columnar Compression and the DML limitations of Basic Compression.

Why Incorrect

A, C, D. Column Store (Hybrid Columnar) Compression is optimized for data warehousing and queries, not OLTP, and incurs significant overhead on DML operations.
B. Basic Table Compression (ROW STORE COMPRESS BASIC) only compresses data during direct-path insert operations, not for conventional DML like standard inserts or updates.

References

1. Oracle Database Concepts 19c

Chapter 12

"Data Blocks

Extents

and Segments"

Section "Space-Saving Features in Blocks"

Subsection "Table Compression".

2. Oracle White Paper

"Advanced Row Compression with Oracle Database 12c"

October 2013. (Explains that Advanced Row Compression is designed for OLTP workloads and compresses data during all DML operations).

Scroll to Top