PrepAway - Latest Free Exam Questions & Answers

How can this stored procedure be called from the Command Line Processor?

Given the following stored procedure:
CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6),
OUT p_sum DECIMAL(9,2) )
SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);
How can this stored procedure be called from the Command Line Processor?

PrepAway - Latest Free Exam Questions & Answers

A.
CALLincrease_salary(‘A00’)

B.
VALUESincrease_salary(‘A00’)

C.
CALLincrease_salary(‘A00’, ?)

D.
VALUESincrease_salary(‘A00’, ?)

One Comment on “How can this stored procedure be called from the Command Line Processor?


Leave a Reply