Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)

The correct answer is A. Only local subroutines can be inlined. C. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2. A: Inlining replaces a subprogram call (to a subprogram in the same program unit) with a copy of the called subprogram. C: If PLSQL_OPTIMIZE_LEVEL=2, YES specifies that the subprogram call is to be inlined. If PLSQL_OPTIMIZE_LEVEL=3, YES specifies that the subprogram call has a…

Improving PL/SQL Performance

Question

Options

AOnly local subroutines can be inlined.
BInlining always reduces the execution time for a PL/SQL program unit.
CPLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.
DThe PL/SQL programs that make use of relatively large helper subroutines are good candidates for

How the community answered

(32 responses)

A
78% (25)
B
9% (3)
D
13% (4)

Explanation

A: Inlining replaces a subprogram call (to a subprogram in the same program unit) with a copy of the called subprogram. C: If PLSQL_OPTIMIZE_LEVEL=2, YES specifies that the subprogram call is to be inlined. If PLSQL_OPTIMIZE_LEVEL=3, YES specifies that the subprogram call has a high priority for

Topics

#subprogram inlining#PLSQL_OPTIMIZE_LEVEL#local subroutines#performance optimization

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice