READ Free Dumps For Oracle- 1z0-144
| Question ID 2639 | Which two statements are correct about the usage of parameters in functions? (Choose two.) |
| Option A | A. Functions can have only in mode parameters. |
| Option B | B. Functions called in SQL statements cannot have out or in outmode parameters. |
| Option C | C. Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms |
| Option D | D. Functions having in, out, or in out parameters can be called In PL/SQL procedures and anonymous blocks. |
| Correct Answer | B,C |
| Question ID 2641 | Examine the following code: |
| Option A | A. It can be used only in a parallelized query. |
| Option B | B. It can be used in both a parallelized query and a parallelized DML statement. |
| Option C | C. It can be used only in a parallelized data manipulation language (DML) statement. |
| Option D | D. It can have a separate copy run in each of the multiple processes when called from a SQL statement that is run in parallel. |
| Option E | E. It requires a PRAGMA RESTRICT_REFERENCES declaration with RNDS, WNDS, RNPS, and WNPS specified in order to use parallel optimization |
| Correct Answer | B,E |
