READ Free Dumps For Oracle- 1z0-117

Question ID 2566	An application issues many expensive join aggregations type queries. Examine the Exhibit to view the queries.     Which two could help improve the performance of these SQL statements without changing application code?
Option A	A.    Create B*-Tree indexes on the join columns.
Option B	B.    Create a materialized view with query rewrite enabled for the first statement and nested MVIEWs for the other statements.
Option C	C.    Collect histogram statistics on columns for which aggregating functions are performed.
Option D	D.    Create an STS for these queries and use SQL Access Advisor, which may generate advice about MVIEWs.
Option E	E.    Create an STS for these queries and use SQL Performance Analyzer, which may generate advice about MVIEWs.
Correct Answer	B,D

Explanation

Question ID 2567	View the exhibit and examine the findings provided by the SQL Tuning Advisor for SELECT Statement.     A SWL plan baseline already exists for the execution plan. What two methods can you use to ensure that an alternate plan becomes an accepted plan?
Option A	A.    Use the DBMS_SPM.ALTER_SQL_PLAN_BASELINE function.
Option B	B.    Use the DBMS_SQLTUNE.CREATE_SQL_PLAN_BASELINE function.
Option C	C.    Use the DBMS_SQLTUNE.CREATE_SQL_PLAN_BASELINE function and run the DBMS_STATS to manually refresh stale statistics.
Option D	D.    Use the DBMS_SPM.LOAD_PLANS_FROM_SQLSET function.
Correct Answer	C,D

Explanation

Previous-Page 1 2. . . 28 29 30 31 32 33 34. . . 60 61 Next-Page

Send email to admin@getfreedumps for new dumps request!!!