Examine the section of code taken from a PL/SQL program:
PLSQL_OPTIMIZE_LEVEL PARAMETER is set to 3.
Which two statements are true?
A. Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.
B. Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.
C. Calls to TESTPROC are not inlined in the line commented as Call 1.
D. Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.
E. Calls to TESTPROC might be inlined in the line commented as Call 2.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
CE
CE
https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/tuning.htm#CHDBGJDJ
Example 12-3 Specifying that a Subprogram Is Not To Be Inlined
PROCEDURE p1 (x PLS_INTEGER) IS …
…
PRAGMA INLINE (p1, ‘NO’);
x:= p1(1) + p1(2) + 17; — These 2 invocations to p1 are inlined
…
x:= p1(3) + p1(4) + 17; — These 2 invocations to p1 might be inlined