Oracle
1Z0-882 · Question #23
1Z0-882 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Question
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?
Options
- AThe procedure completes, and 15 is returned
- BThe procedure's IF condition is not satisfied, and 0 is returned.
- CThe procedure's loop is not entered, and 1 is returned.
- DAn infinite loop will be running until the command is killed.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.