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.
D!
The Text in the box should read “INTERPRETED”, not “INTERFACE”.
Would that help with the answer? 😉
There is not enough info to confirm the option D
Hence answer would be C
If you run the statement, you can see:
ORA-00096: invalid value INTERFACE for parameter plsql_code_type, must be from among NATIVE, INTERPRETED
D
Answer is C—Not A,B or D…ITS C