Which compression option should be used?

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?

Question:

Which compression option should be used?

Options:

ROW STORE COMPRESS

COLUMN STORE COMPRESS FOR QUERY

COLUMN STORE COMPRESS FOR ARCHIVE LOW

ROW STORE COMPRESS ADVANCED

Correct Answer

The Correct Answer for this Question is

ROW STORE COMPRESS ADVANCED