Oracle Database Administration I — Question 119

Which compression method is recommended for Direct-Path Insert operations?

Answer options

• A. ROW STORE COMPRESS BASIC
• B. ROW STORE COMPRESS ADVANCED
• C. COLUMN STORE COMPRESS ADVANCED
• D. COLUMN STORE COMPRESS BASIC

Correct answer: A

Explanation

ROW STORE COMPRESS BASIC is the recommended method for Direct-Path Insert operations because it provides efficient compression while allowing for quick data insertion. The other options, such as ROW STORE COMPRESS ADVANCED and COLUMN STORE COMPRESS variants, are not optimized for this specific operation, potentially leading to slower performance.