/* Formatted on 03/04/2023 09:41:12 (QP5 v5.381) */
DECLARE
past_due EXCEPTION;
acct_num NUMBER;
BEGIN
DECLARE
past_due EXCEPTION;
acct_num NUMBER;
due_date DATE := SYSDATE - 1;
todays_date DATE := SYSDATE;
BEGIN
IF due_date < todays_date
THEN
RAISE past_due;
END IF;
END;
EXCEPTION
WHEN past_due
THEN
DBMS_OUTPUT.PUT_LINE ('Handling PAST_DUE exception');
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ('Could not recognize exception '||sqlerrm);
END;
Correct answer is D, but formulation should say:
"The PAST_DUE exception raised by the enclosing block is propagated to the outer block and it is handled by the WHEN OTHERS exception handler"
The unhandled exception IS propagated to the outer block when local exception handler for the raised exception is not found.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
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.
trex_fcs
1 year, 10 months agoFarmaceits
3 years, 5 months ago