READ Free Dumps For Oracle- 1z0-146
| Question ID 2797 | Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode. (Choose two.) |
| Option A | A. a PL/SQL program which needs to be recompiled frequently |
| Option B | B. a PL/SQL program that spends most of the time executing SQL |
| Option C | C. a PL/SQL program, which performs computation-intensive procedural operations and is recompiled rarely |
| Option D | D. a PL/SQL program, which is called frequently with the same parameter values by multiple sessions and is recompiled rarely |
| Correct Answer | A,B |
| Question ID 2798 | Which two statements are true about REF CURSOR types? (Choose two.) |
| Option A | A. REF CURSOR types cannot be defined inside a package. |
| Option B | B. SYS_REFCURSOR can be used to declare cursor variables in stored procedures and |
| Option C | C. A REF CURSOR return type can be declared using %TYPE, or %ROWTYPE, or a userdefined record. |
| Option D | D. Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function. |
| Correct Answer | B,C |