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?
A.
ROW STORE COMPRESS
B.
COLUMN STORE COMPRESS FOR QUERY
C.
COLUMN STORE COMPRESS FOR ARCHIVE LOW
D.
ROW STORE COMPRESS ADVANCED
confirmed.
– https://docs.oracle.com/database/121/ADMIN/tables.htm#ADMIN-GUID-34D15DD1-0925-4C9A-BE8A-3EE91671E526