1z0-144 Exam - Question 18

Question

Examine the following code:Which two statements are true about the above function? (Choose two. ).

Examice · Accepted Answer

The function defined with PARALLEL_ENABLE can be used in both parallelized queries and parallelized DML statements, as it allows the function to be executed in parallel execution plans. Additionally, having the PARALLEL_ENABLE attribute means that multiple separate copies of the function can run in each process when the SQL statement that calls the function is executed in parallel. This enhances performance by utilizing parallel processing capabilities. Therefore, the correct answers are that it can be used in both a parallelized query and a parallelized DML statement, and it can have a separate copy run in each of the multiple processes when called from a SQL statement that is run in parallel.

sobrinho · Answer

B and D are correct answers. Read documentation bellow to understand why E is not a correct one.

https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/restrictreferences_pragma.htm#LNPLS01339

emmandavies · Answer

B,E is the right answer

Paps23 · Answer

the right answer is BE

maabreh · Answer

BD IS THE RIGHT ANSWER

1z0-144 Exam - Question 18

Discussion