複選題QUESTION 108 Which two statements describe the state of a package variable after executing the package in which it is declared? (Choose two) Short and Long (A) It persists across transactions within a session. (B) It persists from session to session for the same user. (C) It does not persist across transaction within a session. (D) It persists from user to user when the package is invoked. (E) It does not persist from session to session for the same user.

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.

其他試題