READ Free Dumps For Oracle- 1z0-062

Question ID 2390	Examine the parameter for your database instance:   You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:   Identify the reason why the optimizer chose different execution plans.
Option A	A.    The optimizer used a dynamic plan for the query.
Option B	B.    The optimizer chose different plans because automatic dynamic sampling was enabled.
Option C	C.    The optimizer used re-optimization cardinality feedback for the query.
Option D	D.    The optimizer chose different plan because extended statistics were created for the columns used.
Correct Answer	B

Explanation

Question ID 2391	Which three statements are true about adaptive SQL plan management?
Option A	A.    It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
Option B	B.    The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
Option C	C.    It adds new, bettor plans automatically as fixed plans to the baseline.
Option D	D.    The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
Option E	E.    The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
Correct Answer	A,D,E

Explanation

Previous-Page 1 2. . . 27 28 29 30 31 32 33. . . 103 104 Next-Page

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