READ Free Dumps For Oracle- 1z0-117
| Question ID 2572 | Examine the Exhibit and view the query and its execution plan. Which statement is correct about the parallel executions plan? |
| Option A | A. The CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined in parallel. |
| Option B | B. First, the CUSTOMERS table is scanned in parallel, then the SALES table is scanned in parallel, and then they are joined serially. |
| Option C | C. First, the SALES table is scanned in parallel, then the CUSTOMERS table us scanned in parallel, and then they are joined in parallel. |
| Option D | D. The CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined serially. |
| Option E | E. First, the CUSTOMERS table is scanned in parallel, then the SALES table us scanned in parallel, and then they are joined in parallel. |
| Correct Answer | A |
| Question ID 2573 | Which three statements are true the Automatic Tuning Optimizer (ATO)? |
| Option A | A. It identifies the objects with stale or missing statistics and gathers statistics automatically. |
| Option B | B. It investigates the effect of new or modified indexes on the access paths for a workload and recommends running that statistics through the SQL Access Advisor. |
| Option C | C. It recommends a SQL profile to help create a better execution plan. |
| Option D | D. It picks up resource-intensive SQL statements from the ADDM and recommends the use of materialized views to improve query performance. |
| Option E | E. It identifies the syntactic, semantic, or design problems with structure of SQL statements leading to poor performance and suggests restricting the statements. |
| Option F | F. It identifies resource-intensive SQL statements, runs them through the SQL Tuning Advisor, and implements the recommendations automatically. |
| Correct Answer | A,D,F |