📝 Question
#1125
Which of the following is used to input the entry and give the result in a variable in a procedure?
✓
Correct Answer
A. Put and get
💡
Explanation
Create procedure dept count proc(in dept name varchar(20), out d count integer). Here in and out refers to input and result of procedure. 4. Create procedure dept_count proc(in dept name varchar(20), out d count integer) begin select count(*) into d count from instructor where instructor.dept name= dept count proc.dept name end a) Here the ‘Physics’ is in variable and d_count is out variable.
⌨️ Press
A
B
C
D
to select