READ Free Dumps For Oracle- 1z0-117
| Question ID 2506 | Which two statements about In-Memory Parallel Execution are true? |
| Option A | A. It can be configured using the Database Resource Manager. |
| Option B | B. It increases the number of duplicate block images in the global buffer cache. |
| Option C | C. It requires setting PARALLEL_DEGREE_POLICY to LIMITED. |
| Option D | D. Objects selected for In-Memory Parallel Execution have blocks mapped to specific RAC instances. |
| Option E | E. It requires setting PARALLEL_DEGREE_POLICY to AUTO |
| Correct Answer | D,E |
| Question ID 2507 | Which three are benefits of In-Memory Parallel Execution? |
| Option A | A. Reduction in the duplication of block images across multiple buffer caches |
| Option B | B. Reduction in CPU utilization |
| Option C | C. Reduction in the number of blocks accessed |
| Option D | D. Reduction in physical I/O for parallel queries |
| Option E | E. Ability to exploit parallel execution servers on remote instance |
| Correct Answer | A,C,D |