1Z0-146 Exam Dumps | Examine the following settings for a session: PLSQL_CODE_TYPE = NATIVE View the Exhibit and examine the

<< Prev Question Next Question >>

Question 41/47

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?

A. The FUNC1 function would be inlined because the value set for the PLSQL_CODE_TYPE parameter is set to NATIVE.

B. The FUNC1 function would be called inline irrespective of the value set for the PLSQL_OPTIMIZE_LEVEL parameter.

C. The FUNC1 function would not be called inline because the value for the PLSQL_OPTIMIZE_LEVEL parameter is set to a lower value.

D. The FUNC1 function would be called inline because PRAGMA INLINE forces a specific call to
be inlined.

Question 41/47

LEAVE A REPLY

Download PDF File