1Z0-144 · Question #61
Examine the following command: SQL>ALTER SESSION SET plsql_warnings * 'enable: severe', 'enable: performance', 'ERROR: 05003'; What is the implication of the above command?
The correct answer is B. It causes the compilation to fail whenever the warning ERROR.05003 occurs. You can also treat particular messages as errors instead of warnings. For example, if you know that the warning message PLW-05003 represents a serious problem in your code, including 'ERROR:05003' in the PLSQL_WARNINGS setting makes that condition trigger an error message…
Question
Examine the following command:
SQL>ALTER SESSION SET plsql_warnings * 'enable: severe', 'enable: performance', 'ERROR: 05003'; What is the implication of the above command?
Options
- AIt issues a warning whenever ERROR: 05003 occur during compilation.
- BIt causes the compilation to fail whenever the warning ERROR.05003 occurs.
- CIt issues warnings whenever the code causes an unexpected action or wrong results performance
- DIt causes the compilation to fail whenever the code gives wrong results or contains statements
How the community answered
(40 responses)- A3% (1)
- B80% (32)
- C10% (4)
- D8% (3)
Explanation
You can also treat particular messages as errors instead of warnings. For example, if you know that the warning message PLW-05003 represents a serious problem in your code, including 'ERROR:05003' in the PLSQL_WARNINGS setting makes that condition trigger an error message (PLS_05003) instead of a warning message. An error message causes the compilation to fail.
Topics
Community Discussion
No community discussion yet for this question.