GrabCert
HomeExamsProvidersAbout
Sign InSign Up
Home/Exams/Oracle Oracle Technology Certification/Question #5
#5Multiple Choice

You create a table and a stored procedure:
CREATE TABLE t1 (f1 int);
INSERT INTO t1 VALUES (1), (2) , (3), (4), (5);
CREATE PROCEDURE sum_t1()

BEGIN -
DECLARE done INT DEFAULT 0;
DECLARE va1 INT;
DECLARE result CURSOR FOR SELECT f1 FROM t1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
OPEN cur;

REPEAT -
FETCH cur INTO va1;

IF NOT done THEN -
SET result = result +va1;
END IF:
UNTIL done END REPEAT;
SELECT result;

END -
CALL sum_t1();
What is the result of the CALL statement?

Previous
Question 5 of 85
Exam 1Z0-882 Topic 1 Question 6
Back to all questions
Next
GrabCert

Your trusted source for certification exam preparation. Pass your exams with confidence.

Quick Links

  • Home
  • Exams
  • Providers

Legal

  • About
  • Contact Us
  • Refund Policy
  • Privacy Policy
  • Terms of Service

© 2026 GrabCert. All rights reserved.

Sign InSign Up