問題詳情

QUESTION 62Examine this package:CREATE OR REPLACE PACKAGE manage_empsIStax_rate CONSTANT NUMBER(5,2) := .28;v_id NUMBER;PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER);PROCEDURE delete_emp;PROCEDURE update_emp;FUNCTION calc_tax (p_sal NUMBER)RETURN NUMBER;END manage_emps;/CREATE OR REPLACE PACKAGE BODY manage_empsISPROCEDURE update_sal(p_raise_amt NUMBER)ISBEGINUPDATE empSET sal = (sal * p_raise_emt) + salWHERE empno = v_id;END;PROCEDURE insert_emp(p_deptno NUMBER, p_sal NUMBER)ISBEGININSERT INTO emp(empno, deptno, sal)VALYES(v_id, p_depntno, p_sal);END insert_emp;PROCEDURE delete_empISBEGINDELETE FROM empWHERE empno = v_id;END delete_emp;PROCEDURE update_empISv_sal NUMBER(10, 2);v_raise NUMBER(10, 2);BEGINSELECT salINTO v_salFROM empWHERE empno = v_id;IF v_sal < 500 THENv_raise := .05;ELSIP v_sal < 1000 THENv_raise := .07;ELSEv_raise := .04;END IF;update_sal(v_raise);END update_emp;FUNCTION calc_tax(p_sal NUMBER)RETURN NUMBERISBEGINRETURN p_sal * tax_rate;END calc_tax;END manage_emps;/How many public procedures are in the MANAGE_EMPS package?
(A)One
(B)Two
(C)Three
(D)Four
(E)Five

參考答案

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