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

Identify the two correct interpretations that can be made from the execution plan.

Select all that apply.

• A

  The DEPT table is driving table and the EMP table join is the driven table.

• B

  Rows from the DEPT table are first hashed by the join key into memory and then joined to the EMP table on the join key.

• C

  The EMP table is the driving table and the DEPT table us the driven table.

• D

  The rows from the DEPT table are sorted first by the join key and then hashed into memory.

• E

  Rows from both the tables are sorted by the join key, but only rows from the DEPT table are hashed into memory.