問題詳情

QUESTION 61Examine this procedure:CREATE OR REPLACE PROCEDURE DELETE_PLAYER(V_ID IN NUMBER)ISBEGINDELETE FROM PLAYERWHERE ID = V_ID;EXCEPTIONWHEN STATS_EXITS_EXCEPTIONTHEN DBMS_OUTPUT.PUT_LINE('Cannot delete this player, child records exist in PLAYER_BAT_STAT table');END;What prevents this procedure from being createdsuccessfully?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.

參考答案

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