多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

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', ?)
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题