Oracle Database Administration 2022 Certified Professional — Question 28

Which three statements are true about using the In Memory (IM) column store? (Choose three.)

Answer options

• A. It does not improve performance for queries using cached results of function evaluations on columns from the same table.
• B. It does not improve performance for queries that use join groups on columns from different tables.
• C. It can improve OLTP workload performance by avoiding the use of indexes.
• D. It does not improve performance for queries using user-defined virtual column results.
• E. It does not require all database data to fit in memory to improve query performance.
• F. It improves performance for queries joining several tables using bloom filter joins.

Correct answer: C, E, F

Explanation

Option C is correct because the In Memory column store can optimize OLTP performance by reducing the reliance on indexing. Option E is also accurate as it allows for performance improvements without the entire database needing to reside in memory. Option F is correct as well, as bloom filter joins can significantly enhance query performance across multiple tables. The other options are incorrect as they describe scenarios where the In Memory column store does not provide performance benefits.