PLSQL_CODE_TYPE = NATIVE
PLSQL_OPTIMIZE_LEVEL = 2
Which two statements are true in this scenario? (Choose two.)
A.
The compiler automatically inlines subprograms even if you specify that they not be inlined.
B.
The compiler optimizes PL/SQL programs by elimination of unnecessary computations and exceptions.
C.
PL/SQL statements in a PL/SQL program unit are compiled into machine-readable code, and stored in the SYSTEM tablespace.
D.
PL/SQL statements in a PL/SQL program unit are compiled into an intermediate form, machine-readable code, which is stored in the database dictionary.
B, C
http://www.oracle.com/technetwork/testcontent/o39ocp-087552.html
http://twelvec.com/tag/alter-session-set-plsql_code_type-native/
one qeustion: if the plsql_code_type=interpeted, where is the compiled program unit stored? In SYSTEM table space or USER table space?