Free 1Z0-148 Web TestEngine Demo

Q12 Multiple choice

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.)

Select all that apply.

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.

1Z0-148 Web TestEngine demo