問題詳情

QUESTION 102Examine this function:CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG(V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE)RETURN NUMBERISV_AVG NUMBER;BEGINSELECT HITS / AT_BATSINTO V_AVGFROM PLAYER_BAT_STATWHERE PLAYER_ID = V_ID;RETURN (V_AVG);END;Which statement will successfully invoke this function in SQL *Plus?long
(A)SELECT CALC_PLAYER_AVG(PLAYER_ID)FROM PLAYER_BAT_STAT;
(B)EXECUTE CALC_PLAYER_AVG(31);
(C)CALC_PLAYER('RUTH');
(D)CALC_PLAYER_AVG(31);
(E)START CALC_PLAYER_AVG(31)

參考答案

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