試題詳解

QUESTION 61 Examine this procedure: CREATE OR REPLACE PROCEDURE DELETE_PLAYER (V_ID IN NUMBER) IS BEGIN DELETE FROM PLAYER WHERE ID = V_ID; EXCEPTION WHEN STATS_EXITS_EXCEPTION THEN DBMS_OUTPUT.PUT_LINE ('Cannot delete this player, child records exist in PLAYER_BAT_STAT table'); END; What prevents this procedure from being created successfully? L
(A) A comma has been left after the STATS_EXIST_EXCEPTION exception.
(B) The STATS_EXIST_EXCEPTION has not been declared as a number.
(C) The STATS_EXIST_EXCEPTION has not been declared as an exception.
(D) Only predefined exceptions are allowed in the EXCEPTION section.