Question 17 Evaluate the following: BEGIN FOR i IN 1.10 LOOP IF1-4 OR I-6 THÊN null; 10, ELSE i+1; INSERT INTO test(result) VALUES (I); END IF; COMMIT; END LOOP; ROLL BACK END. How many values will be inserted into the test table? Blank 1 NB: Write only the number.

Question 17 Evaluate the following: BEGIN FOR i IN 1.10 LOOP IF1-4 OR I-6 THÊN null; 10, ELSE i+1; INSERT INTO test(result) VALUES (I); END IF; COMMIT; END LOOP; ROLL BACK END. How many values will be inserted into the test table? Blank 1 NB: Write only the number.

Name: Question 17Evaluate the following:BEGINFOR i IN 1.10 LOOPIF1-4 ORI-6
Uploaded: 2024-03-20T06:51:23.000Z
Channel: Bartleby
Description: Question 17Evaluate the following:BEGINFOR i IN 1.10 LOOPIF1-4 ORI-6 THÊN null;1-0,ELSEINSERT INTO test(result)VALUES (I);END IF;COMMIT;END LOOPROLL BACKEND.How many values will be inserted into the test table? Blank 1NB: Write only the number.Blank

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

How many times will the following loop be executed? for (i = 2; i<= 14; i = i + 3) {body of loop; } Select one: O a. 13 O b. 5 O c. 12 O d. 4
c) Correct the following piece of code: int records[],cc; do while (cc<20) {printf(“%d “,record[c]); } d) Correct the following codes: For (unsigned i=0, i<7, i--) printf(“%d\n",i); You are required to Correct the following code. int *pf,g; *pf= g; printf(“value of g is %d",pf);
Question 8 1 Point how many times this loop will be repeated:- int i=100; while(i<101) { i++; } 2 Question 9 1 Point if N is negative and M is positive this expression (N !=M) evaluates A) false B) false && true true D) Itrue Question 10 1 Point output:- int x=14; switch(x%3) { case 0: case 5:System.out.print(x);break; case 2: case 3:System.out.print(++x/6);break; default:System.out.print(--x/3);break; }
in the next sequence, say whether the loop is finite or infinite. If the loop is finite, give the final value of the variable "total"; otherwise, if the loop is infinite, explain why. Counter← 1 total ← 0 2. do begin total ← total + 2 end while (counter <=6) Memory counter integer ? total integer ? counter <=6 boolean ? Loop Finite infinite Total value total
5. How many times following loop will execute? 1 KINGDOM OF SAUDI ARABIA | JAZAN UNIYERSITY COLLEGE OF COMPUTER SCIENCE & INFORMATION SYSTEMS ASSIGNMENTI - 2018-2019 i=4 while(ib) print (a): else if (a
QUESTION 9 Consider the steps you would take to write code that prints the output (below) meeting these criteria: • Use a while loop. • Declare a loop-control variable called noofSteps that is to be tested against 12. *****Output***** Step 1 Step 2 Step 3 <== Not part of actual output. .. Step 12 Choose the correct response to answer each question: 1) What is the means of stopping the while loop? 2) What is this while loop doing? 3) How is the loop-control variable modified? 4) Rather than testing noofSteps against 12, another valid test expression is
True or False: When asking user for data, we can always turn an algorithm that uses a user-confirmation loop into one that uses a sentinel loop. Select one: a. False b. True
How many time will the loop run? int count = 8; while( count <= 34 ) { count++; }
How many times is the body of the loop executed? int i = 1; while (i<10) { cout << i; if (i == 5) break; i++; }
Q6:Rewrite the following Matlab code using a while loop to avoid using the beak command. Pu c; clear; limit=300; m=50; sum=0; for i=1:m end sum n=i sum-sum+i; if sum>limit break end
What is the total number of iterations in the following loop ? for (int i=0; i<9; i+=2-1)
. How many times will the following loop run? int i = 0; while (i < 10) { cout << i << endl; i=i+2; }