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
Get step-by-step solutions from verified subject matter experts
