Oracle
1Z0-144 · Question #5
1Z0-144 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-144 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Question
You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded. The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors. Which construct should be used to handle this requirement?
Options
- AThe SQLERRM function
- BThe PRAGMA EXCEPTION_INIT function
- CThe RAISE_APPLICATION_ERROR procedure
- DA user-defined exception used with a raise statement
Unlock 1Z0-144 to see the answer
You've previewed enough free 1Z0-144 questions. Unlock 1Z0-144 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.