Which statement would be true in this scenario?

View the Exhibit and examine the settings for the PLSQL_CODE_TYPE parameter.

After sometime, the user recompiles the procedure DISPLAY_SAL_INFO by issuing the following command:
SQL> ALTER PROCEDURE display_sal_info COMPILE;
Which statement would be true in this scenario?

View the Exhibit and examine the settings for the PLSQL_CODE_TYPE parameter.

After sometime, the user recompiles the procedure DISPLAY_SAL_INFO by issuing the following command:
SQL> ALTER PROCEDURE display_sal_info COMPILE;
Which statement would be true in this scenario?

A.
The procedure would be invalidated.

B.
The procedure would remain as NATIVE code type.

C.
The procedure would be changed to INTERPRETED code type.

D.
The command would produce an error and the procedure must be compiled using the
PLSQL_CODE_TYPE attribute with value INTERPRETED.

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

Leo Yu

Leo Yu

question: what does “REUSE” mean? The compile will keep the NATIVE code type if “ALTER FUNCTION COMPILE REUSE SETTINGS?

During recompilation, Oracle Database drops all persistent compiler switch settings, retrieves them again from the session, and stores them at the end of compilation. To avoid this process, specify the REUSE SETTINGS clause.

Reply