Upgrade to Oracle Database 12c

216 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

Examine the parameters for your database instance:

Oracle 1z0-060

You generate an execution plan for this query and the plan table shows a nested loop join in the plan :

Oracle 1z0-060

After query execution, you see that a hash join was performed:

What explain this optimizer behavior?

Choose the correct option from the given list.
01 / 216

0 Discussions

Trending Exams