Evaluate the following: BEGIN FOR I IN 1..10 LOOP IF 1-4 OR 1-6 THEN null; 1:=0; ELSE 1:=i+1; INSERT INTO test(result) VALUES (1); END IF; COMMIT; END LOOP; ROLL BACK; END. How many values will be inserted into the test table? 0 NB: Write only the number.

C++ Programming: From Problem Analysis to Program Design
8th Edition
ISBN:9781337102087
Author:D. S. Malik
Publisher:D. S. Malik
Chapter5: Control Structures Ii (repetition)
Section: Chapter Questions
Problem 31SA
icon
Related questions
Question
Evaluate the following:
BEGIN
FOR I IN 1..10 LOOP
IF 1-4 OR 1=6 THEN null;
1:=0;
ELSE
1:=i+1;
INSERT INTO test(result)
VALUES (1);
END IF;
COMMIT;
END LOOP;
ROLL BACK;
END.
How many values will be inserted into the test table? 0
NB: Write only the number.
Transcribed Image Text:Evaluate the following: BEGIN FOR I IN 1..10 LOOP IF 1-4 OR 1=6 THEN null; 1:=0; ELSE 1:=i+1; INSERT INTO test(result) VALUES (1); END IF; COMMIT; END LOOP; ROLL BACK; END. How many values will be inserted into the test table? 0 NB: Write only the number.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Linux
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning