Oracle
1Z0-146 · Question #123
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.)
The correct answer is 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. See the full explanation below for the reasoning.
Question
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.)
Options
- AThe compiler automatically inlines subprograms even if you specify that they not be inlined.
- BThe compiler optimizes PL/SQL programs by elimination of unnecessary computations and exceptions.
- CPL/SQL statements in a PL/SQL program unit are compiled into machine-readable code, and stored
- DPL/SQL statements in a PL/SQL program unit are compiled into an intermediate form, machine-readable
How the community answered
(16 responses)- A6% (1)
- B81% (13)
- D13% (2)
Community Discussion
No community discussion yet for this question.