QUESTION 110
Examine this code:
CREATE OR REPLACE PACKAGE bonus
IS
g_max_bonus NUMBER := .99;
FUNCTION calc_bonus (p_emp_id NUMBER)
RETURN NUMBER;
FUNCTION calc_salary (p_emp_id NUMBER)
RETURN NUMBER;
END;
/
CREATE OR REPLACE PACKAGE BODY bonus
IS
v_salary employees.salary%TYPE;
v_bonus employees.commission_pct%TYPE;
FUNCTION calc_bonus (p_emp_id NUMBER)
RETURN NUMBER
IS
BEGIN
SELECT salary, commission_pct
INTO v_salary, v_bonus
FROM employees
WHERE employee_id = p_emp_id;
RETURN v_bonus * v_salary;
END calc_bonus
FUNCTION calc_salary (p_emp_id NUMBER)
RETURN NUMBER
IS
BEGIN
SELECT salary, commission_pct
INTO v_salary, v_bonus
FROM employees
WHERE employees
RETURN v_bonus * v_salary + v_salary;
END cacl_salary;
END bonus;
/
Which statement is true?
(A) You can call the BONUS.CALC_SALARY packaged function from an INSERT command against the EMPLOYEES table.
(B) You can call the BONUS.CALC_SALARY packaged function from a SELECT command against the EMPLOYEES table.
(C) You can call the BONUS.CALC_SALARY packaged function form a DELETE command against the EMPLOYEES table.
(D) You can call the BONUS.CALC_SALARY packaged function from an UPDATE command against the EMPLOYEES table.
阿摩線上測驗
登入