DATABASE CONCEPTS, QUERIES AND FUNCTIONS

1. Q. 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 Which of the following is used to call the procedure given above? | 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) Declare d_count integer;

(B) Declare d_count integer; call dept_count proc('Physics', d_count);

(C) Declare d_count integer; call dept _count proc('Physics');

(D) Declare d_count; call dept_count proc('Physics', d_count);