Examine the Exhibit and view the query and its execution plan. Which statement is correct about the parallel executions plan?

The correct answer is D. The CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined serially. Line 7 and line 11 are run in parallel. Line 8 and line 12 are run in parallel. Line 9 and line 13 are run in parallel. Line 10 and line 14 are run in parallel. Line 6 serially joins the two parallel scan (resulting from line 7 and 11). * PX BLOCK ITERATOR The PX BLOCK ITERATOR…

Monitoring and Analyzing SQL Performance

Question

Exhibits

Options

AThe CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined in parallel.
BFirst, the CUSTOMERS table is scanned in parallel, then the SALES table is scanned in parallel,
CFirst, the SALES table is scanned in parallel, then the CUSTOMERS table us scanned in parallel,
DThe CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined serially.
EFirst, the CUSTOMERS table is scanned in parallel, then the SALES table us scanned in parallel,

How the community answered

(22 responses)

A
9% (2)
B
14% (3)
C
5% (1)
D
73% (16)

Explanation

Line 7 and line 11 are run in parallel. Line 8 and line 12 are run in parallel. Line 9 and line 13 are run in parallel. Line 10 and line 14 are run in parallel. Line 6 serially joins the two parallel scan (resulting from line 7 and 11). * PX BLOCK ITERATOR The PX BLOCK ITERATOR row source represents the splitting up of the table EMP2 into pieces so as to divide the scan workload between the parallel scan slaves.

Topics

#parallel execution plan#parallel table scan#hash join#execution plan analysis

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice