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
Please see the candidate agreement section 3.3 regarding disclosure. The postings in this thread both violate that agreement, please edit or remove them.
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."