問題詳情

QUESTION 30Examine this code:CREATE OR REPLACE PROCEDURE add_dept( p_name departments.department_name%TYPE DEFAULT'unknown',p_loc departments.location_id%TYPE DEFAULT 1700)ISBEGININSERT INTO departments(department_id, department_name, loclation_id)VALUES(dept_seq.NEXTVAL,p_name, p_loc);END add_dept;/You created the add_dept procedure above, and you now invoke the procedure in SQL *Plus.Which four are valid invocations? (Choose four)
(A)EXECUTE add_dept(p_loc=>2500)
(B)EXECUTE add_dept('Education', 2500)
(C)EXECUTE add_dept('2500', p_loc =>2500)
(D)EXECUTE add_dept(p_name=>'Education', 2500)
(E)EXECUTE add_dept(p_loc=>2500, p_name=>'Education')

參考答案

答案:A,C,D,E
難度:非常困難0
統計:A(1),B(1),C(0),D(0),E(0)