問題詳情

QUESTION 110Examine this code:CREATE OR REPLACE PACKAGE bonusISg_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 bonusISv_salary employees.salary%TYPE;v_bonus employees.commission_pct%TYPE;FUNCTION calc_bonus (p_emp_id NUMBER)RETURN NUMBERISBEGINSELECT salary, commission_pctINTO v_salary, v_bonusFROM employeesWHERE employee_id = p_emp_id;RETURN v_bonus * v_salary;END calc_bonusFUNCTION calc_salary (p_emp_id NUMBER)RETURN NUMBERISBEGINSELECT salary, commission_pctINTO v_salary, v_bonusFROM employeesWHERE employeesRETURN 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.

參考答案

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