複選題
QUESTION 53
Examine this code:
CREATE OR REPLACE FUNCTION calc_sal(p_salary NUMBER) RETURN NUMBER
IS
v_raise NUMBER(4,2) DEFAULT 1.08;
BEGIN
RETURN 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 employees
WHERE department_id = 60;
(C) DELETE FROM employees(calc_sal(salary))
WHERE calc_sal(salary) > 1000;
(D) SELECT salary, calc_sal(salary)
FROM employees
WHERE department_id = 60;
(E) SELECT last_name, salary, calc_sal(salary)
FROM employees ORDER BY
calc_sal(salary);
阿摩線上測驗
登入