Oracle
1Z0-064 · Question #4
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…
The correct answer is A. Check whether direct path load operations are used to insert rows in the table. B. Check whether the table is frequently queried using full table scans as column store compression D. Check whether the table has LOB columns as it will minimize I/O for the queries. See the full explanation below for the reasoning.
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.
How the community answered
(41 responses)- A80% (33)
- C12% (5)
- E7% (3)
Community Discussion
No community discussion yet for this question.