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?

Question

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?

Accepted Answer

A. SELECT CALC_PLAYER_AVG(PLAYER_ID) FROM PLAYER_BAT_STAT;

Answer

B. EXECUTE CALC_PLAYER_AVG(31);

Answer

C. CALC_PLAYER('Ruth');

Answer

D. CALC_PLAYER_AVG(31);

Answer

E. START CALC_PLAYER_AVG(31)

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…

Question

Options

How the community answered

Community Discussion