Oracle Database 11g: Program with PL/SQL — Question 56

Examine the following command:

SQL>ALTER SESSION -
SET plsql_warnings *
'enable: severe',
'enable: performance',
'ERROR: 05003';
What is the implication of the above command?

Answer options

• A. It issues a warning whenever ERROR: 05003 occur during compilation.
• B. It causes the compilation to fail whenever the warning ERROR.05003 occurs.
• C. It issues warnings whenever the code causes an unexpected action or wrong results performance problems.
• D. It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.

Correct answer: B

Explanation

The correct answer is B because the command specifically configures the session to treat the ERROR: 05003 as a severe warning that will cause compilation to fail. Options A and C misinterpret the severity of the error, as they suggest warnings rather than a failure. Option D incorrectly states that it pertains to incorrect results or unreachable code, which does not align with the specific warning set by the command.