Which two statements are true in this scenario?

Examine the following parameter values for a session:
PLSQL_CODE_TYPE = NATIVE
PLSQL_OPTIMIZE_LEVEL = 2
Which two statements are true in this scenario? (Choose two.)

Examine the following parameter values for a session:
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

where the intepreted plsql code store?