P Precreate Procedure Deptcount Procin Dept Name Varchar20 Out #385

</p> <pre><code class="language-text">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 </code></pre> <p>Which of the following is used to call the procedure given above ?

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Functions and Procedures - Quiz No.1.

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 

Declare d_count integer;

 Declare d_count integer; call dept_count proc(’Physics’, d_count);

 Declare d_count integer; call dept_count proc(’Physics’);

 Declare d_count; call dept_count proc(’Physics’, d_count);