Oracle
1Z0-146 · Question #92
Examine the following settings for a session: PLSQL_CODE_TYPE = NATIVE View the Exhibit and examine the PL/SQL code. You compile the program with the following attributes: SQL> ALTER PROCEDURE proc1…
The correct answer is D. The FUNC1 function would not be called inline because the value for the PLSQL_OPTIMIZE_LEVEL. See the full explanation below for the reasoning.
Question
Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE View the Exhibit and examine the PL/SQL code. You compile the program with the following attributes:
SQL> ALTER PROCEDURE proc1 COMPILE PLSQL_OPTIMIZE_LEVEL = 1; Which statement is true about the execution of the PROC1 procedure in this scenario?
Exhibit
Options
- AThe FUNC1 function would be called inline because PRAGMA INLINE forces a specific call to be inlined.
- BThe FUNC1 function would be inlined because the value set for the PLSQL_CODE_TYPE parameter
- CThe FUNC1 function would be called inline irrespective of the value set for the PLSQL_OPTIMIZE_LEVEL
- DThe FUNC1 function would not be called inline because the value for the PLSQL_OPTIMIZE_LEVEL
How the community answered
(54 responses)- A6% (3)
- B2% (1)
- C13% (7)
- D80% (43)
Community Discussion
No community discussion yet for this question.