試題詳解

複選題
QUESTION 38 Examine this procedure: CREATE OR REPLACE PROCEDURE UPD_BAT_STAT (V_ID IN NUMBER DEFAULT 10, V_AB IN NUMBER DEFAULT 4) IS BEGIN UPDATE PLAYER_BAT_STAT SET AT_BATS = AT_BATS + V_AB WHERE PLAYER_ID = V_ID; COMMIT; END; Which two statements will successfully invoke this procedure in SQL *Plus? (Choose two)
(A) EXECUTE UPD_BAT_STAT;
(B) EXECUTE UPD_BAT_STAT(V_AB=>10, V_ID=>31);
(C) EXECUTE UPD_BAT_STAT(31, 'FOUR','TWO');
(D) UPD_BAT_STAT(V_AB=>10, V_ID=>31);
(E) RUN UPD_BAT_STAT;