nerdexam
Oracle

1Z0-146 · Question #126

1Z0-146 Question #126: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #126. The question stem and answer options stay visible for context.

Question

The PLSQL_OPTIMIZE_LEVEL parameter is set to 2 for the session. Examine the section of code given: FUNCTION p2 (p boolean) return PLS_INTEGER IS ... FUNCTION p2 (x PLS_INTEGER) return PLS_INTEGER IS ... ... PRAGMA INLINE(p2, 'YES'); x := p2(true) + p2(3); ... Which statement is true about the INLINE pragma procedure calls?

Options

  • AOnly the call to the P2 function with BOOLEAN as the argument is inlined.
  • BINLINE pragma affects both the functions named P2 and is called inline.
  • COnly the call to the P2 function with PLS_INTEGER as the argument is inlined.
  • DNone of the functions are inlined because inlining is not supported for overloaded functions.

Unlock 1Z0-146 to see the answer

You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-146 Practice