Oracle Database 12c: Installation and Administration — Question 86

You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct-path INSERT and conventional DML.
The table will also be used for queries.
Which compression option should be used?

Answer options

• A. ROW STORE COMPRESS
• B. COLUMN STORE COMPRESS FOR QUERY
• C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D. ROW STORE COMPRESS ADVANCED

Correct answer: D

Explanation

The correct answer is D, ROW STORE COMPRESS ADVANCED, as it allows for efficient compression during both direct-path INSERT and conventional DML operations, which is essential for an OLTP application. The other options either focus on query optimization or archive purposes, which do not meet the specific requirements of the application for both insertion and querying.