Which two statements are true about the handling of internally defined or user-defined PL7SQL
exceptions? (Choose two.)
A.
Add exception handlers whenever errors occur.
B.
An exception handler should commit the transaction.
C.
Handle named exceptions whenever possible instead of using when others in exception
handlers
D.
Instead of adding exception handlers to your PL/SQL block, check for errors at every point
where they may occur.
Explanation:
A and C
http://docs.oracle.com/cd/B13789_01/appdev.101/b10807/07_errs.htm#i3880
“A” and “C”
Can somebody fix the answer here? as previously mentioned, the answes are A and C as per vishesh and Leonid comments
A,C
C,D
A C
D is not correct.
http://docs.oracle.com/cd/B13789_01/appdev.101/b10807/07_errs.htm#i3880
“Instead of checking for an error at every point it might occur, just add an exception handler to your PL/SQL block.”
I agree with you. Correct answers are: A & C because of what is said in the link you provided:
http://docs.oracle.com/cd/B13789_01/appdev.101/b10807/07_errs.htm#i3880
A -> is CORRECT because : “Add exception handlers whenever there is any possibility of an error occurring”
C -> is CORRECT because : “Handle named exceptions whenever possible, instead of using WHEN OTHERS in exception handlers”
B -> is wrong because : Carefully consider whether each exception handler should commit the transaction, roll it back, or let it continue.
D -> is WRONG because : “Instead of checking for an error at every point it might occur, just add an exception handler to your PL/SQL block.” -> which is exactly the opposite of what they are saying in answer D
Very few internet sites that transpire to be in depth beneath, from our point of view are undoubtedly nicely worth checking out.
that would be the finish of this article. Right here you will discover some web sites that we think you will value, just click the hyperlinks over
here are some links to sites that we link to due to the fact we think they are worth visiting
here are some hyperlinks to web-sites that we link to because we think they may be really worth visiting
one of our guests not long ago advised the following website
just beneath, are many totally not connected web pages to ours, nevertheless, they’re certainly really worth going over
the time to read or go to the content material or web-sites we’ve linked to below the
that will be the end of this report. Here you will uncover some sites that we assume you will value, just click the hyperlinks over
Sites of interest we have a link to
check below, are some absolutely unrelated web sites to ours, nonetheless, they are most trustworthy sources that we use
that could be the end of this report. Right here you will come across some internet sites that we think you will value, just click the hyperlinks over
ac
Answer: A & C
A – True
B – False: will not implicit or auto commit;
C – True: Handle named exceptions whenever possible, instead of using WHEN OTHERS in exception handlers.
http://docs.oracle.com/cd/B13789_01/appdev.101/b10807/07_errs.htm#i3880
D – False: Instead of checking for an error at every point it might occur, just add an exception handler to your PL/SQL block. http://docs.oracle.com/cd/B13789_01/appdev.101/b10807/07_errs.htm#i3880