What two statements are true?

Examine the exhibit to view the query and its execution plan?


What two statements are true?

A.
The HASH GROUP BY operation is the consumer of the HASH operation.

B.
The HASH operation is the consumer of the HASH GROUP BY operation.

C.
The HASH GROUP BY operation is the consumer of the TABLE ACCESS FULL operation for
the CUSTOMER table.

D.
The HASH GROUP BY operation is consumer of the TABLE ACCESS FULL operation for the
SALES table.

E.
The SALES table scan is a producer for the HASH JOIN operation.

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).