Oracle
1Z0-074 · Question #24
The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?
The correct answer is B. for query performance and space saving. Explanation/Reference: https://docs.oracle.com/database/121/REFRN/GUID-5772F775-2A3E-4BC8-AA03- B8FF383BEE52.htm#REFRN10350
New Features for Performance
Question
The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?
Options
- Afor parallel query performance only
- Bfor query performance and space saving
- Cfor query performance and space saving with greater bias toward space saving
- Dfor query performance only
- Efor space saving only
How the community answered
(66 responses)- A8% (5)
- B71% (47)
- C17% (11)
- D3% (2)
- E2% (1)
Explanation
Explanation/Reference: https://docs.oracle.com/database/121/REFRN/GUID-5772F775-2A3E-4BC8-AA03- B8FF383BEE52.htm#REFRN10350
Topics
#In-Memory compression#MEMCOMPRESS FOR QUERY HIGH#columnar store#query performance
Community Discussion
No community discussion yet for this question.