Choose all the correct options

Question

consider the stored procedurecreate procedure param_test (in p_in int,out p_out int,input p_inout int)beginselect p_in, p_out, p_ inout;set p_in, p_inoutendyou execute a series of commands:what is the output of the call and select?

Accepted Answer

(0,0,0) and (0,0,0)

Answer

(0,0,0,) and (0,200,300)

Answer

(0,NULL,0) and(0,200,300)

Answer

(0,NULL,0) and (100,200,300)

Consider the stored procedure
CREATE PROCEDURE param_test (
IN P_in INT,
OUT P_out INT,
INPUT P_inout INT)
BEGIN
SELECT P_in, P_out, P_ inout;
SET P_in, P_inout
END
You execute a series of commands:

0 Discussions

Trending Exams

Consider the stored procedureCREATE PROCEDURE param_test (IN P_in INT,OUT P_out INT,INPUT P_inout INT)BEGINSELECT P_in, P_out, P_ inout;SET P_in, P_inoutENDYou execute a series of commands:

0 Discussions

Trending Exams

Consider the stored procedure
CREATE PROCEDURE param_test (
IN P_in INT,
OUT P_out INT,
INPUT P_inout INT)
BEGIN
SELECT P_in, P_out, P_ inout;
SET P_in, P_inout
END
You execute a series of commands: