READ Free Dumps For Oracle- 1z0-117
| Question ID 2548 | View the code sequence: |
| Option A | A. The optimizer joins specified tables in the order as they appear in the FROM clause. |
| Option B | B. The CUSTOMERS and ORDERS tables are joined first and the resultant is then joined with rows returned by the ORDER_ITEMS table. |
| Option C | C. The CUSTOMERS and ORDER_ITEMS tables are joined first the resultant is then joined with rows by the ORDERS table. |
| Option D | D. The optimizer has chosen hash join as an access method as the OPTIMIZER_MODE parameter is set to FIRST_ROWS. |
| Correct Answer | C,D |
| Question ID 2549 | Examine the parallelism parameters for your instance:
|
| Option A |
A. It will execute in parallel only if the LINEITEM table has a dictionary DOP defined. |
| Option B | B. DOP for the statement is determined by the dictionary DOP of the accessed objects. |
| Option C | C. It is generated to execute in parallel. |
| Option D | D. It will execute in parallel only if the estimated execution time is 10 or more seconds. |
| Option E | E. DOP for the statement is calculated automatically. |
| Option F | F. It may execute serially. |
| Correct Answer | E,F |
