Which two statements are true in this scenario?

PLSQL_CODE_TYPE = NATIVE
PLSQL_OPTIMIZE_LEVEL = 2
Which two statements are true in this scenario? (Choose two.)

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

one qeustion: if the plsql_code_type=interpeted, where is the compiled program unit stored? In SYSTEM table space or USER table space?