READ Free Dumps For Oracle- 1z0-117
Question ID 2601 | Examine the exhibit to view the query and its execution plan. Identify the two correct interpretations that can be made from the execution plan. |
Option A | A. The DEPT table is driving table and the EMP table join is the driven table. |
Option B | B. Rows from the DEPT table are first hashed by the join key into memory and then joined to the EMP table on the join key. |
Option C | C. The EMP table is the driving table and the DEPT table us the driven table. |
Option D | D. The rows from the DEPT table are sorted first by the join key and then hashed into memory. |
Option E | E. Rows from both the tables are sorted by the join key, but only rows from the DEPT table are hashed into memory. |
Correct Answer | B,C |
Question ID 2602 | You are administering a database that supports a DSS workload, where in an application a set of queries use the query rewrite on materialized views. You notice that these queries are performing poorly. |
Option A | A. Use DBMS_MVIEW.EXPLAIN_REWRITE to analyze whether the queries are rewritten. |
Option B | B. USE DBMS_ADVISOR.QUICK_TUNE to analyze the query rewrite usage of materialized views for the entire workload. |
Option C | C. Create an STS for all the queries and use SQL performance Analyzer to generate recommendations for determining the regressed SQL statements. |
Option D | D. Create an STS for all the queries in the application and use the SQL Tuning Advisor to generate recommendations. |
Option E | E. Create an STS for all the queries in the application and use the SQL Access Advisor to generate a recommendation for optimizing materialized views for maximum query rewrite usage |
Correct Answer | D,E |