Which two options are true about the execution plan and the set of statements?

Examine the Exhibit.

Which two options are true about the execution plan and the set of statements?

A.
The query uses a partial partition-wise join.

B.
The degree of parallelism is limited to the number of partitions in the EMP_RANGE_DID table.

C.
The DEPT table id dynamically distributed based on the partition keys of the
EMP_RANGE_DID table.

D.
The server process serially scans the entire DEPT table for each range partition on the
EMP_RANGE_DID table.

E.
The query uses a full partition-wise join.

Explanation:
Note the “px partition range all” in the execution plan.
Note:
* PX PARTITION RANGE (ALL)
Description
Parallel execution – iterate over all range partitioned table

* Full partition-wise joins can occur if two tables that are co-partitioned on the same key are joined
in a query. The tables can be co-partitioned at the partition level, or at the subpartition level, or at a
combination of partition and subpartition levels. Reference partitioning is an easy way to
guarantee co-partitioning. Full partition-wise joins can be executed serially and in parallel.
* Oracle Database can perform partial partition-wise joins only in parallel. Unlike full partition-wise
joins, partial partition-wise joins require you to partition only one table on the join key, not both
tables. The partitioned table is referred to as the reference table. The other table may or may not
be partitioned. Partial partition-wise joins are more common than full partition-wise joins.
To execute a partial partition-wise join, the database dynamically partitions or repartitions the other
table based on the partitioning of the reference table. After the other table is repartitioned, the
execution is similar to a full partition-wise join.