1Z0-144 · Question #4
Which two statements are true about the handling of internally defined or user-defined PL/SQL exceptions? (Choose two.)
The correct answer is A. Add exception handlers wherever errors can occur. C. Whenever possible, write exception handlers for named exceptions instead of using OTHERS. Errors are especially likely during arithmetic calculations, string manipulation, and database operations. Errors can also arise from problems that are independent of your code - for example, disk storage or memory hardware failure - but your code still must take corrective…
Question
Which two statements are true about the handling of internally defined or user-defined PL/SQL exceptions? (Choose two.)
Options
- AAdd exception handlers wherever errors can occur.
- BAn exception handler should commit the transaction.
- CWhenever possible, write exception handlers for named exceptions instead of using OTHERS
- DInstead of adding exception handlers to your PL/SQL block, check for errors at every point where
How the community answered
(34 responses)- A76% (26)
- B15% (5)
- D9% (3)
Explanation
Errors are especially likely during arithmetic calculations, string manipulation, and database operations. Errors can also arise from problems that are independent of your code - for example, disk storage or memory hardware failure - but your code still must take corrective action. exception handlers. Learn the names and causes of the predefined exceptions. If you know that your database operations might raise specific internally defined exceptions that do not have names, then give them names so that you can write exception handlers specifically for them.
Topics
Community Discussion
No community discussion yet for this question.