Oracle
1Z0-064 · Question #4
1Z0-064 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of queries on some large tables. Which three aspects should you consider before you choose this compression method? (Choose three.)
Options
- ACheck whether direct path load operations are used to insert rows in the table.
- BCheck whether the table is frequently queried using full table scans as column store compression
- CCheck whether the table is frequently updated because it will have overhead for insert and update
- DCheck whether the table has LOB columns as it will minimize I/O for the queries.
- ECheck whether the table blocks are sparsely populated as this will defragment the blocks.
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.