複選題
QUESTION 105
Examine this code:
CREATE OR REPLACE PRODECURE add_dept
(p_dept_name VARCHAR2 DEFAULT 'placeholder',
p_location VARCHAR2 DEFAULT 'Boston')
IS
BEGIN
INSERT INTO departments
VALUES (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');.
阿摩線上測驗
登入