READ Free Dumps For Oracle- 1z0-117
| Question ID 2607 | Examine the Exhibit to view the structure of and indexes for the EMPLOYEES and DEPARTMENTS tables: |
| Option A | A. Step 2 is performing nested operation on JOB_ID column of the JOBS table, which is the driven table and the EMPLOYEES table is the driven table. |
| Option B | B. In step 2 for every row returned by the JOBS table matching rows from the EMPLOYEES table are accessed. |
| Option C | C. Step 1 is performing nested loop operation on the DEPARTMENT_ID column of the DEPARTMENTS table, which is the driven table and results returned by step 2 in the driving resultset. |
| Option D | D. The performance of the query can be improved by creating bitmap index on the JOB_ID column of the EMPLOYEES table. |
| Option E | E. The performance of the query can be improved by creating bitmapped index on the DEPARTMENT_ID column of the EMPLOYEES table. |
| Correct Answer | A,C |
| Question ID 2608 | Which two statements are true about the use of the DYNAMIC_SAMPLING hint in a query? |
| Option A | A. It estimates selectivity better for the filters. |
| Option B | B. It is always used for flashback queries that contain the AS OF clause. |
| Option C | C. It cannot be used if there is a single-table predicate in the WHERE clause. |
| Option D | D. It cannot be used for processing SQL statements in parallel. |
| Option E | E. It can compensate for the lack of extended statistics to get accurate cardinality estimates for complex predicate expressions. |
| Correct Answer | D,E |