Examine this code CREATE OR REPLACE FUNCTION change_dept (p_old_id NUMBER, p_deptname VARCHAR2) RETURN NUMBER IS V_new_id NUMBER; BEGIN SELECT departments_seq.nextval INTO v_new_id FROM dual; UPDATE departments SET departmenet_id = v_new_id, Department_name = p_deptname WHERE department_id = p_old_id; Return v_new_id; END; /
There are no foreign key integrity constraints on the EMPLOYEES and DEPARTMENTS tables. Which statement performs a successful update to the EMPLOYEES table?

• A. UPDATE departments
  change_dept(270, 'Outsource')
  Where department_name = 'payroll';
• B. UPDATE employees
  SET department_id = change_dept(10, 'Finance')
  Where department_id = 10;
• C. UPDATE departments
  SET department_id = change_dept(10, 'Finance')
  Where department_id = 10;
• D. UPDATE employees
  SET department_id = change_dept(10, 'Finance')
  Where department_id = DEPARTMENTS:CURRVAL;

The add_player, upd_player_stat, and upd_pitcher_stat procedures are grouped together in a package. A variable must be shared among only these procedures.
Where should you declare this variable?

• A. In each procedure's DECLARE section, using the exact same name in each.
• B. In a database trigger.
• C. In the package specification.
• D. In the package body.

Which two statements about functions are true? (Choose two.)

• A. Client-side functions can be used in SOL statements
• B. From SOL*Plus, a function can be executed by giving the command EXECUTE functionname;
• C. A stored function that is called from a SOL statement can return a value of any PL/SOL variable data type
• D. A stored function increases efficiency of queries by performing functions on the server rather than in the application
• E. A function must have a return statement in its body to execute successfully

All users currently have the INSERT privilege on the PLAYER table. You only want your users to insert into this table using the ADD_PLAYTER procedure. Which two actions must you take? (Choose two)

• A. GRANT INSERT ON PLAYER TO PUBLIC;
• B. GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;
• C. REVOKE INSERT ON PLAYER FROM PUBLIC;
• D. GRANT EXECUTE,INSERT ON ADD_PLAYER TO PUBLIC;
• E. GRANT SELECT ON ADD_PLAYER TO PUBLIC;

Examine this package:
CREATE OR REPLACE PACKAGE manage_emps IS tax_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_emps IS PROCEDURE update_sal (p_raise_amt NUMBER) IS BEGIN UPDATE emp SET sal = (sal * p_raise_emt) + sal WHERE empno = v_id; END; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER) IS BEGIN INSERT INTO emp(empno, deptno, sal) VALYES(v_id, p_depntno, p_sal); END insert_emp; PROCEDURE delete_emp IS BEGIN DELETE FROM emp WHERE empno = v_id; END delete_emp; PROCEDURE update_emp IS v_sal NUMBER(10, 2); v_raise NUMBER(10, 2); BEGIN SELECT sal INTO v_sal FROM emp WHERE empno = v_id;
IF v_sal < 500 THEN
v_raise := .05;
ELSIP v_sal < 1000 THEN
v_raise := .07;
ELSE
v_raise := .04;
END IF;
update_sal(v_raise);
END update_emp;
FUNCTION calc_tax
(p_sal NUMBER)
RETURN NUMBER
IS
BEGIN
RETURN p_sal * tax_rate;
END calc_tax;
END manage_emps;
/
What is the name of the private procedure in this package?

• A. INSERT_EMP
• B. UPDATE_EMP
• C. UPDATE_SAL
• D. DELETE_EMP
• E. CALC_TAX
• F. MANAGE_EMPS