問題詳情

QUESTION 27Examine this procedure:CREATE OR REPLACE PROCEDURE INSERT_TEAM(V_ID in NUMBER, V_CITY in VARCHAR2 DEFAULT 'AUSTIN', V_NAME in VARCHAR2)ISBEGININSERT INTO TEAM (id, city, name)VALUES (v_id, v_city, v_name);COMMIT;ENDWhich two statements will successfully invoke this procedure in SQL *Plus? (Choose two)
(A)EXECUTE INSERT_TEAM;
(B)EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS',V_CITY=>'AUSTIN');
(C)EXECUTE INSERT_TEAM(3, 'AUSTIN','LONGHORNS');
(D)EXECUTE INSERT_TEAM (V_ID := V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
(E)EXECUTE INSERT_TEAM (3, 'LONGHORNS');

參考答案

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