Question No 1
Examine the following SQL statement:
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;
What is the result of executing this statements?
A. The PL/SQL optimize level for some existing PL/SQL units will be changed as animmediate result.
B. The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.
C. The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.
D. This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,
Answer: C
No comments:
Post a Comment