QUESTION 95Examine this codeCREATE OR REPLACE FUNCTION change_dept(p_old_id NUMBER, p_deptname VARCHAR2)RETURN NUMBERISv_new_id NUMBERBEGINSELECT departments_seq.nextvalINTO v_new_idFROM dual;UPDATE departmentsSET departmenet_id = v_new_id,Department_name = p_deptnameWHERE 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 departmentsSET department_id = change_dept(10, 'Finance')Where dapartment_id=10;
(B)UPDATE employeesSET department_id = change_dept(10, 'Finance')Where dapartment_id=10;
(C)UPDATE departmentschange_dept(270, 'Outsource')Where dapartment_name='payroll';
(D)UPDATE employeesSET department_id = change_dept(10, 'Finance')WHERE department_id = DEPARTMENTS:CURRVAl;