Examine the exhibit to view the query and its execution plan? What two statements are true?

The correct answer is A. The HASH GROUP BY operation is the consumer of the HASH operation. E. The SALES table scan is a producer for the HASH JOIN operation. A, not C, not D: Line 3, HASH GROUP BY, consumes line 6 (HASH JOIN BUFFERED). E: Line 14, TABLE ACCESS FULL (Sales), is one of the two producers for line 6 (HASH JOIN).

Understanding and Influencing the Optimizer

Question

Exhibit

Options

AThe HASH GROUP BY operation is the consumer of the HASH operation.
BThe HASH operation is the consumer of the HASH GROUP BY operation.
CThe HASH GROUP BY operation is the consumer of the TABLE ACCESS FULL operation for the
DThe HASH GROUP BY operation is consumer of the TABLE ACCESS FULL operation for the SALES table.
EThe SALES table scan is a producer for the HASH JOIN operation.

How the community answered

(29 responses)

A
83% (24)
B
10% (3)
C
3% (1)
D
3% (1)

Explanation

A, not C, not D: Line 3, HASH GROUP BY, consumes line 6 (HASH JOIN BUFFERED). E: Line 14, TABLE ACCESS FULL (Sales), is one of the two producers for line 6 (HASH JOIN).

Topics

#execution plan#HASH JOIN#HASH GROUP BY#producer-consumer

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice