Oracle
1Z0-882 · Question #16
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…
The correct answer is C. (0,NULL,0) and(0,200,300). See the full explanation below for the reasoning.
Question
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:
What is the output of the CALL and SELECT?
Options
- A(0,0,0) and (0,0,0)
- B(0,0,0,) and (0,200,300)
- C(0,NULL,0) and(0,200,300)
- D(0,NULL,0) and (100,200,300)
How the community answered
(20 responses)- A15% (3)
- B5% (1)
- C75% (15)
- D5% (1)
Community Discussion
No community discussion yet for this question.