READ Free Dumps For Oracle- 1z0-117
| Question ID 2590 | Examine the execution plan: |
| Option A | A. The CUSTOMERS table is hash partitioned. |
| Option B | B. The SALES table is hash partitioned. |
| Option C | C. The CUSTOMERS table is scanned first and selected partitions from the SALES table are scanned based on the BLOOM Filter created during the scan of the CUSTOMERS table. |
| Option D | D. The SALES table is scanned first and selected partitions from the CUSTOMERS table are scanned based on the Bloom Filter created during the scan of the SALES table. |
| Option E | E. Both the CUSTOMERS and SALES tables are scanned simultaneously and rows from the CUSTOMERS table are joined to row of the SALES table. |
| Option F | F. The CUSTOMERS table is range partitioned. |
| Correct Answer | B,C |
| Question ID 2591 | Which two tasks are performed during the optimization stage of a SQL statement? |
| Option A | A. Evaluating the expressions and conditions in the query |
| Option B | B. Checking the syntax and analyzing the semantics of the statement |
| Option C | C. Separating the clauses of the SQL statement into structures that can be processed |
| Option D | D. Inspecting the integrity constraints and optimizing the query based on this metadata |
| Option E | E. Gathering the statistics before creating the execution plan for the statement |
| Correct Answer | D,E |