Examine the exhibit to view the query and its execution plan?
What two statements are true?
Exhibit:
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |