Multiple choice technology databases

If parallelism is used in a DML then PX COORDINATOR should be below DML operation in the EXPLAIN PLAN ?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In an EXPLAIN PLAN for a parallel DML operation, the PX COORDINATOR appears ABOVE the DML operation, not below. The coordinator orchestrates parallel execution servers that perform the actual DML. The plan shows the coordinator as the parent operation managing the parallel workers.

Keep practicing — related questions