READ Free Dumps For Oracle- 1z0-117
| Question ID 2580 | Which three statements are true about the usage of optimizer hints? |
| Option A | A. Whenever a query uses table aliases, the hints in the query must use the aliases. |
| Option B | B. The OPTIMIZER_FEATURES_ENABLE parameter must be set to a version supports the hints used. |
| Option C | C. The optimizer uses the execution plan with lower cost even if a hint is specified. |
| Option D | D. A schema name for the table must be used in the hint if the table us qualified in the FROM clause. |
| Option E | E. Hints can be used to override the optimization approach specified with the OPTIMIZER_MODE parameter. |
| Option F | F. A statement block can have only one hint, and that hint must be immediately after SELECT, UPDATE, INSERT, MERGE, or DELETE keyword. |
| Correct Answer | A,B,E |
| Question ID 2581 | Which three tasks are performed by the parallel execution coordinator process? |
| Option A | A. Allocating parallel execution processes from the parallel execution server pool. |
| Option B | B. Determining the parallel execution method for each operation in the execution plan. |
| Option C | C. Managing the data flow between the producers and consumers during inter-operation parallelism. |
| Option D | D. Any serial processing that is part of the execution plan. |
| Option E | E. Determining the desired number of parallel execution processes |
| Option F | F. Managing the data flow between the producers and consumers during intra-operation parallelism. |
| Correct Answer | A,B,C |