ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-144 All Questions

View all questions & answers for the 1z0-144 exam
Go to Exam

Exam 1z0-144 topic 1 question 2 discussion

Actual exam question from Oracle's 1z0-144
Question #: 2
Topic #: 1
[All 1z0-144 Questions]

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 Suggested Answer Hide Answer
Suggested Answer: B 🗳️
References:
by Limak665 at May 30, 2021, 9:03 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Paps23
2 years, 3 months ago
C is right!
upvoted 1 times
Paps23
2 years, 3 months ago
sorry B is right
upvoted 1 times
...
...
ZaurBaghirzade
3 years, 7 months ago
I think answer B is wrong because there is no ERROR.05003 warning, it is 05003. my answer is C.
upvoted 2 times
Aditya
2 years, 10 months ago
B is right
upvoted 1 times
...
...
Limak665
3 years, 8 months ago
I think it should be BC due to 'enable: severe'
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago