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 questionsFor 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.
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.
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).
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
