Oracle

1Z0-074 · Question #7

In which situation can the optimizer choose a hash join?

The correct answer is D. when an equality operator is used. Explanation/Reference:

Displaying Data from Multiple Tables Using Joins

Question

In which situation can the optimizer choose a hash join?

Options

Awhen a non-equijoin is used and the join column in at least one of the tables is a primary key
Bwhen a non-equijoin is used and the join column for both tables is a primary key
Cwhen a non-equijoin is used between a table and a sorted hash cluster
Dwhen an equality operator is used
Ewhen any self-join is done

How the community answered

(25 responses)

A
12% (3)
B
4% (1)
C
4% (1)
D
76% (19)
E
4% (1)

Explanation

Explanation/Reference:

Topics

#hash join#query optimizer#equality join#join selection

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-074 Practice