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?
A. CALL increase_salary(‘A00’)
B. VALUES increase_salary(‘A00’)
C. CALL increase_salary(‘A00’, ?)
D. VALUES increase_salary(‘A00’, ?)
|
Download Printable PDF. VALID exam to help you PASS. |
 |