What is the implication of the above command?

Examine the following command:
SQL>ALTER SESSION
SET plsql_warnings *
‘enable:severe’,
‘enable:performance’,
‘ERROR:05003’;

Examine the following command:
SQL>ALTER SESSION
SET plsql_warnings *
‘enable:severe’,
‘enable:performance’,
‘ERROR:05003’;

What is the implication of the above command?

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.

Show Hint

← Previous question

Leave a Reply 24

sictacuisses

I examined this site:
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/errors.htm

In my opinion answer C is genuine gibberish. “Performance problems” seem to be copied and pasted from this page without any relation to the rest of the sentence. Did anyone ever see this question in the exam?

This is the original text:
“•SEVERE: Messages for conditions that might cause unexpected behavior or wrong results, such as aliasing problems with parameters.

•PERFORMANCE: Messages for conditions that might cause performance problems, such as passing a VARCHAR2 value to a NUMBER column in an INSERT statement.”

ankur

B is for sure. not sure about C.

kar

C is sure not sure of B

Tana

B and C for sure they are both of the warning charactaristcs

abhishek

hey has any1 cleared the exam studying only these dumps here???

sushma

HI..are these dumps enough to clear the test? please let me know..
Thankyou

ninchi

in my opinion, B is more corrected than C.
ERROR:Treat a specific warning or a set of warnings as errors

Sid

Aarti

i think B is correct.

Alonso

“ERROR.05003” is not a warning code, just 05003

I have marked answer C on my exam and it was wrong answer, so I guess B is correct. Pretty strange cause “ERROR:05003” is not a warning code, just 05003 :/

lik

are these enough for clearing exam ?
hi po,

does these dumps enough to clera exam

S!d

C is surely not the answer as per Exam Engine because today i marked my option C and it proved out to be a wrong option. Another better answer would then be 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 (PLS_05003) instead of a warning message. An error message causes the compilation to fail.

ANS : B

reference : http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/errors.htm