Question: How many rows will be inserted into the tab1 table after the following PL/SQL block has been executed successfully (no runtime error)? DECLARE v_count NUMBER

How many rows will be inserted into the tab1 table after the following PL/SQL block has been executed successfully (no runtime error)?

DECLARE

v_count NUMBER := 1;

v_1 NUMBER := 1;

BEGIN

DELETE FROM tab1;

COMMIT;

FOR i IN REVERSE 6..11 LOOP

INSERT INTO tab1 VALUES (i, i*2, i+3);

END LOOP;

SELECT COUNT(*)

INTO v_count

FROM tab1;

FOR i IN 3..v_count + 11 LOOP

INSERT INTO tab1 VALUES (i, i+10, i+20);

END LOOP;

INSERT INTO tab1 VALUES (99, 205, 306);

SELECT COUNT(*)

INTO v_1

FROM tab1;

WHILE v_1 >= 7 LOOP

IF v_1 = 10 OR v_1 = 25 OR v_1 = 35 OR v_1 = 45 THEN

INSERT INTO tab1 VALUES (v_1*20, v_1*30, v_1*40);

ELSE

v_1 := v_1 - 1;

END IF;

v_1 := v_1 - 2;

END LOOP;

FOR i IN 2..48 LOOP

IF i = 4 OR i = 16 OR i= 32 OR i = 48 THEN

INSERT INTO tab1 VALUES (i*20, i*30, i*40);

END IF;

INSERT INTO tab1 VALUES (i*21, i*31, i*41);

END LOOP;

INSERT INTO tab1 VALUES (616, 222, 243);

INSERT INTO tab1 VALUES (77, 88, 99);

INSERT INTO tab1 VALUES (77, 88, 55);

INSERT INTO tab1 VALUES (66, 88, 99);

INSERT INTO tab1 VALUES (66, 88, 91);

COMMIT;

END;

A. 75

B. 76

C. 77

D. 78

E. 79

F 80

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!