QUESTION 111 Which statement is valid when removing procedures? short 單行 (A) Use a drop procedure statement to drop a standalone procedure. (B) Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package specification. (C) Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package body. (D) For faster removal and re-creation, do not use a drop procedure statement. Instead, recompile the procedure using the alter procedure statement with the REUSE SETTINGS clause.

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.

其他試題