問題詳情

QUESTION 53Examine this code:CREATE OR REPLACE FUNCTION calc_sal(p_salary NUMBER) RETURN NUMBERISv_raise NUMBER(4,2) DEFAULT 1.08;BEGINRETURN v_raise * p_salary;END calc_sal;/Which statement accurately call the stored function CALC_SAL? (Choose two)3行
(A)UPDATE employees (calc_sal(salary))SET salary = salary * calc_sal(salary);
(B)INSERT calc_sal(salary) INTO employeesWHERE department_id = 60;
(C)DELETE FROM employees(calc_sal(salary))WHERE calc_sal(salary) > 1000;
(D)SELECT salary, calc_sal(salary)FROM employeesWHERE department_id = 60;
(E)SELECT last_name, salary, calc_sal(salary)FROM employees ORDER BYcalc_sal(salary);

參考答案

答案:D,E
難度:非常困難0
統計:A(1),B(1),C(0),D(0),E(0)