Oracle
1Z0-146 · Question #126
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…
The correct answer is B. INLINE pragma affects both the functions named P2 and is called inline. See the full explanation below for the reasoning.
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.
How the community answered
(54 responses)- A2% (1)
- B83% (45)
- C4% (2)
- D11% (6)
Community Discussion
No community discussion yet for this question.