Oracle Exam 1Z0-064 Topic 9 Question 31 Discussion

You have been asked to use table compression for two large tables. Given are the details of the tables:

The TRANS_DET table:

The table is used by an OLTP application.

High volume insert and update operations are performed on the table.

The table is frequently queried using index range scans.

The TRANS_HISTORY table:

The table is used by a DSS application.

High volume bulk loads are performed on the table.

The table is used to store archival data on which large table full-table scans (FTS) are performed.

Which row store compression would you recommend for these tables with minimal overhead on performance? (Choose the best answer.)