QUESTION 95
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
SET department_id = change_dept(10, 'Finance')
Where dapartment_id=10;
(B) UPDATE employees
SET department_id = change_dept(10, 'Finance')
Where dapartment_id=10;
(C) UPDATE departments
change_dept(270, 'Outsource')
Where dapartment_name='payroll';
(D) UPDATE employees
SET department_id = change_dept(10, 'Finance')
WHERE department_id = DEPARTMENTS:CURRVAl;
阿摩線上測驗
登入