View the code sequence: Examine the Exhibit to view the execution plan. Which two statements are true about the query execution?

The correct answer is C. The CUSTOMERS and ORDER_ITEMS tables are joined first the resultant is then joined with rows D. The optimizer has chosen hash join as an access method as the OPTIMIZER_MODE parameter is. The first executed join is in line 6. The second executed join is in line 1. A: Line 7 and 8 are executed first.

Understanding and Influencing the Optimizer

Question

View the code sequence:

Examine the Exhibit to view the execution plan. Which two statements are true about the query execution?

Exhibits

Options

AThe optimizer joins specified tables in the order as they appear in the FROM clause.
BThe CUSTOMERS and ORDERS tables are joined first and the resultant is then joined with rows
CThe CUSTOMERS and ORDER_ITEMS tables are joined first the resultant is then joined with rows
DThe optimizer has chosen hash join as an access method as the OPTIMIZER_MODE parameter is

How the community answered

(24 responses)

A
13% (3)
B
8% (2)
C
79% (19)

Explanation

The first executed join is in line 6. The second executed join is in line 1. A: Line 7 and 8 are executed first.

Topics

#join order#hash join#OPTIMIZER_MODE#join hints

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice