READ Free Dumps For Oracle- 1z0-117
| Question ID 2588 | Examine the query and its execution plan: |
| Option A | A. For every row of CUSTOMERS table, the row matching the join predicate from the ORDERS table are returned. |
| Option B | B. An outer join returns NULL for the ORDERS table columns along with the CUSTOMERS table rows when it does not find any corresponding rows in the ORDER table. |
| Option C | C. The data is aggregated from the ORDERS table before joining to CUSTOMERS. |
| Option D | D. The NESTED LOOP OUTER join is performed because the OPTIMZER_MODE parameter is set to ALL_ROWS. |
| Correct Answer | B,D |
| Question ID 2589 | An application frequently executed similar types of queries that vary only in the usage of literals in the WHERE clause. You plan to use bind variable in place of literal values. |
| Option A | A. The number of latch gets in the library cache will be reduced. |
| Option B | B. Bind peeking will take place and subsequent execution of queries can have different plans based on the cardinality of the bind value in the column. |
| Option C | C. Bind peeking will take place and subsequent execution of queries can have different plans only when the histograms exists on a column used in WHERE clause. |
| Option D | D. Bind peeking will not happen and the optimizer will use the same plan for all bind values if no histograms exist on a column use in the WHERE clause. |
| Option E | E. Bind peeking will happen and subsequent execution of queries will have the same parent cursor |
| Correct Answer | A,E |