Thursday, February 25, 2010

Examine this function.

Examine this function.

CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG
(V_ID IN PLAYER_BAT_STAT. PLAYER_ID%TYPE)
RETURN NUMBER
IS
V_AVG NUMBER;
BEGIN
SELECT HITS/AT_BATS
INTO V_AVG
FROM PLAYER_BAT_STAT
WHERE PLAYER_ID=V_ID;
RETURN(V_AVG);
END;


Which statement will successfully invoke this function in SQL Plus?
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)



Answer: B