1z0-515 Question :- What would you do to compress data in partitions that are frequently updated in Oracle database 11g?
As per testking.com the answer is
Option A – Use Hybrid Columnar Compression
But as per http://www.expertoracleexadata.com/
• Records that will be updated should not be compressed to eliminate row migration.
• Locking issues :- Updating a single row of a table compressed with HCC locks the entire compression unit containing the row. This can cause extreme contention issues for OLTP-type systems. This is the main reason that HCC is not recommended for tables (or partitions) where the data will be updated.
Please can I know what the correct answer is?
The other options for the above 1z0-515 questions are :-
Option B User Advanced Compression Option
Option C User Hybrid Partitions
Option D Avoid compression any data
Pretty typical of the answers to these tests which is why I don't take them, give them, or recommend them.
Answer A assumes someone has an Exadata laying around but this is a DW test an nothing in the question indicates Exadata is an option.
Answer B is the only plausible answer.
Answer C references a technology not found in the Oracle online docs so I have no idea what it is.
and Answer D is out-of-scope based on the wording of the question. The question is not "should you compress."