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.



Leave a Reply 7

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


khurshid

khurshid

oooh i understood, B is true