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.
A.
The optimizer used a dynamic plan for the query.
B.
The optimizer chose different plans because automatic dynamic sampling was enabled.
C.
The optimizer used re-optimization cardinality feedback for the query.
D.
The optimizer chose different plan because extended statistics were created for the
columns used.
B
B
A
A
B
sorry, C – right
A is correct, the only resource that changes the plan during the execution are the dynamic plans.
B is wrong, dynamic sampling is only enable if the parameter optimizer_dynamic_sampling is 11.
C is wrong, re-optimization only work on the next execution of the SQL.
Hi, i have passed my Oracle 1Z0-060 exam last week, score of my 1Z0-060 exam: Section 1 = 90%; Section 2 = 92% (the passing score: Section 1 = 64%; Section 2 = 65%, both sections must be passed to pass 1Z0-060 exam). All 85 questions (Section 1 = 51q; Section 2 = 34q) were multiple choice questions, most of them were easy to answer, but few questions on Core Administration and Performance Management were a little difficult.
And, I learned valid 1Z0-060 dumps here: http://www.passleader.com/1z0-060.html (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).
Good Luck!
P.S. Free 1Z0-060 PDF dumps from Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs
Thanks a lot for sharing the dump NOLL.