Oracle
1Z0-117 · Question #75
1Z0-117 Question #75: Real Exam Question with Answer & Explanation
The correct answer is D. Each process in SS1 reads all the rows from the SALES table and distributes the rows evenly among. The execution starts with line 16 (accessing the SALES table), followed by line 15. PX BLOCKITERATOR 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. The PX SEND and PX R
Question
Examine the Exhibit. Given two sets of parallel execution processes, SS1 and SS2, which is true?
Exhibit
Options
- AEach process SS1 reads some of the rows from the CUSTOMERS table and sends all the rows it
- BEach process in SS1 reads all the rows from the CUSTOMERS table and distributes the rows evenly
- CEach process in SS1 reads some of the rows from the SALES table and sends all the rows it reads to
- DEach process in SS1 reads all the rows from the SALES table and distributes the rows evenly among
- EEach process in SS1 reads some of the rows from the SALES table and distributes the rows evenly
- FEach process in the SS1 reads some of the rows from the CUSTOMERS table and distributes the rows
Explanation
- The execution starts with line 16 (accessing the SALES table), followed by line 15. * PX BLOCKITERATOR 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. The PX SEND and PX RECEIVE row sources represent the pipe that connects the two slave sets as rows flow up from the parallel scan, get repartitioned through the HASHtable queue, and then read by and aggregated on the top slave set.
Community Discussion
No community discussion yet for this question.