Which two statements are true about the PL/SQL initialization parameters? (Choose two.)
A.
To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.
B.
The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.
C.
Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.
D.
Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled
A n D are wrong..
http://docs.oracle.com/cd/E11882_01/appdev.112/e17126/overview.htm
A C
PLSQL_CODE_TYPE = { INTERPRETED | NATIVE } used to native compilation
A) wrong
The optimizer is enabled by default. In rare cases, if the overhead of the optimizer makes compilation of very large applications too slow, you can lower the optimization by setting the compilation parameter PLSQL_OPTIMIZE_LEVEL=1 instead of its default value 2. In even rarer cases, PL/SQL might raise an exception earlier than expected or not at all. Setting PLSQL_OPTIMIZE_LEVEL=1 prevents the code from being rearranged.
B) true
C) true
Dependencies, Invalidation, and Revalidation
Recompilation is automatic with invalidated PL/SQL modules. For example, if an object on which a natively compiled PL/SQL subprogram depends changes, the subprogram is invalidated. The next time the same subprogram is called, the database recompiles the subprogram automatically. Because the PLSQL_CODE_TYPE setting is stored inside the library unit for each subprogram, the automatic recompilation uses this stored setting for code type.
Explicit recompilation does not necessarily use the stored PLSQL_CODE_TYPE setting. For the conditions under which explicit recompilation uses stored settings, see “PL/SQL Units and Compilation Parameters”.
D) false
B, C
B,C
B, C
Good post! We are linking to this particularly great content on our website. Keep up the good writing.|
b,c