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?

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?

Accepted Answer

D. An infinite loop will be running until the command is killed.

Answer

A. The procedure completes, and 15 is returned

Answer

B. The procedure's IF condition is not satisfied, and 0 is returned.

Answer

C. The procedure's loop is not entered, and 1 is returned.

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…

Question

Options

How the community answered

Community Discussion