READ Free Dumps For Oracle- 1z0-117
| Question ID 2502 | Which four statements are correct about communication between parallel execution process? |
| Option A | A. The number of logical pathways between parallel execution producers and consumers depends on the degree parallelism. |
| Option B | B. The shared pool can be used for parallel execution messages buffers. |
| Option C | C. The large pool can be used for parallel execution messages buffers. |
| Option D | D. The buffer cache can be used for parallel execution message buffers. |
| Option E | E. Communication between parallel execution processes is never required if a query uses full partition-wise joins. |
| Option F | F. Each parallel execution process has an additional connection to the parallel execution coordinator. |
| Correct Answer | A,B,E,F |
| Question ID 2503 | You have enabled DML by issuing: ALTER session ENABLE PARALLEL DML; |
| Option A | A. Statements for which PDML is requested will execute serially estimated time is less than the time specified by the PARALLEL_MIN_THRESHOLD parameter. |
| Option B | B. Statements for which PDML is requested will be queued if the number of busy parallel execution servers greater than PARALLEL_MIN_SERVERS parameter. |
| Option C | C. Statements for which PDML is requested will always execute in parallel if estimated execution in parallel if estimated execution time is greater than the time specified by the PARELLEL_MIN_TIME_THRESHOLD parameter. |
| Option D | D. Statements for which PDML is requested will be queued if the number of busy parallel execution servers is greater than PARELLEL_SERVERS_TARGET parameter. |
| Option E | E. Statement for which PDML is requested will be queued if the number of busy parallel execution servers is greater than PARELLEL_DEGREE_LIMIT parameter. |
| Correct Answer | C,D |