複選題
QUESTION 30
Examine this code:
CREATE OR REPLACE PROCEDURE add_dept
( p_name departments.department_name%TYPE DEFAULT
'unknown',
p_loc departments.location_id%TYPE DEFAULT 1700)
IS
BEGIN
INSERT 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')
阿摩線上測驗
登入