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 6

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


KPD

KPD

The Text in the box should read “INTERPRETED”, not “INTERFACE”.
Would that help with the answer? 😉

Arun

Arun

There is not enough info to confirm the option D
Hence answer would be C

Dani

Dani

If you run the statement, you can see:
ORA-00096: invalid value INTERFACE for parameter plsql_code_type, must be from among NATIVE, INTERPRETED

Mugabe

Mugabe

Answer is C—Not A,B or D…ITS C