Multiple choice technology databases

BEGIN . . . BEGIN IF X=1 THEN RAISE A: ELSEIF X=2 THEN RAISE B; ELSE RAISE C; EXCEPTION WHEN A THEN . . . END; EXCEPTION WHEN B THEN . . . END; Whar will happen to exception B

  1. The exception B will be handled in inner block

  2. The exception B will be handled in outer block exception handler

  3. The exception will not be handled as there is no handler defined for B in inner block

  4. The exception section in inner block is executed and also Outer block exception section as we have defined there too
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When exception B is raised in the inner block's ELSE clause, it has no matching handler in that inner block (which only handles A). Unhandled exceptions propagate to the enclosing block, where B is caught. Option B correctly describes this propagation behavior.

Keep practicing — related questions