I have 4 questions about PL/SQL. Please help me. Thanks 1. To which of the follo

Question

I have 4 questions about PL/SQL. Please help me. Thanks

1. To which of the following will an exception raised in the DECLARATION section of the block B_3 propagate?

     <<B_4>>

     DECLARE

          v_4 NUMBER;

          v_5 NUMBER;

     BEGIN

          v_4 := 10;

          v_5 := v_4 + 80;

          <<B_3>>

          DECLARE

               v_3 NUMBER := 90;

               v_4 NUMBER := v_3 / (v_3 - v_5);

-- Run-time error, propagate to?

          BEGIN

               v_3 := v_3 * v_4 + 1;

               v_4 := v_3 + v_4;

          EXCEPTION

               WHEN OTHERS THEN

                     DBMS_OUTPUT.PUT_LINE('ERROR (B_3)!');

          END B_3;

          v_4 := v_4 * v_4;

          <<B_2>>  

          DECLARE

               v_2 NUMBER := 0;

               v_5 NUMBER := v_4;            

          BEGIN

Explanation / Answer

Answers:

1. C4        - The B_4 block

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.