Oracle Database Administration I — Question 78

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?

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: E

Explanation

The ROW STORE COMPRESS ADVANCED option is designed specifically for OLTP workloads, providing effective row compression while minimizing performance impacts. The other options either cater to specific query or archive needs, or do not optimize for the performance requirements of DML operations in an OLTP environment.