問題詳情

QUESTION 105Examine this code:CREATE OR REPLACE PRODECURE add_dept(p_dept_name VARCHAR2 DEFAULT 'placeholder',p_location VARCHAR2 DEFAULT 'Boston')ISBEGININSERT INTO departmentsVALUES (dept_id_seq.NEXTVAL, p_dept_name, p_location); END add_dept;/Which three are valid calls to the add_dep procedure? (Choose three)
(A)add_dept;
(B)add_dept('Accounting');
(C)add_dept(, 'New York');
(D)add_dept(p_location=>'New York');.

參考答案

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