nerdexam
Oracle

1Z0-146 · Question #27

Examine the section of code taken from a PL/SQL program: PROCEDURE p1 (x PLS_INTEGER) IS ... ... PRAGMA INLINE (p1, 'NO'); x:= p1(1) + p1(2) + 17; -- Call 1 ... x:= p1(3) + p1(4) + 17; -- Call 2…

The correct answer is A. The calls to the P1 procedure are not inlined in the section commented as Call 1. B. The calls to the P1 procedure might be inlined in the section commented as Call 2. The INLINE pragma affects only the immediately following declaration or statement, and only some kinds of statements.

Improving PL/SQL Performance

Question

Examine the section of code taken from a PL/SQL program:

PROCEDURE p1 (x PLS_INTEGER) IS ... ... PRAGMA INLINE (p1, 'NO'); x:= p1(1) + p1(2) + 17; -- Call 1 ... x:= p1(3) + p1(4) + 17; -- Call 2 Call 1 and Call 2 are the comments for distinguishing the code. The PLSQL_OPTIMIZE_LEVEL parameter is set to 3. Which two statements are true in this scenario? (Choose two.)

Options

  • AThe calls to the P1 procedure are not inlined in the section commented as Call 1.
  • BThe calls to the P1 procedure might be inlined in the section commented as Call 2.
  • CThe calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2.
  • DThe calls to the P1 procedure are never inlined in both the sections commented as Call 1 and Call 2.

How the community answered

(50 responses)
  • A
    70% (35)
  • C
    18% (9)
  • D
    12% (6)

Explanation

The INLINE pragma affects only the immediately following declaration or statement, and only some kinds of statements.

Topics

#PRAGMA INLINE#subprogram inlining#PLSQL_OPTIMIZE_LEVEL#compiler directives

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-146 Practice