READ Free Dumps For Oracle- 1z0-117
Question ID 2535 | Examine the following query and execution plan: |
Option A | A. Join predicate push-down |
Option B | B. Subquery factoring |
Option C | C. Subquery unnesting |
Option D | D. Join conversion |
Correct Answer | A |
Question ID 2537 | You enabled auto degree of parallelism (DOP) for your instance. |
Option A | A. Dictionary DOP will be used, if present, on the tables referred in the query. |
Option B | B. DOP is calculated if the calculated DOP is 1. |
Option C | C. DOP is calculated automatically. |
Option D | D. Calculated DOP will always by 2 or more. |
Option E | E. The statement will execute with auto DOP only when PARALLEL_DEGREE_POLICY is set to AUTO. |
Correct Answer | A,C |