問題詳情

QUESTION 98Examine this package:CREATE OR REPLACE PACKAGE BB_PACKISV_MAX_TEM_SALARY NUMBER(12,2);PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAMEVACHAR 2,V_SALARY NUMBER);END BB_PACk;/CREATE OR REPLACE PACKAGE BODY BB_PACKISV_PLAYER_AVG NUMBER84,3);PROCEDURE UPD_PLAYER_STAT(V_ID IN NUMBER, V_AB IN NUMBER DEFAULT 4, V_HITS IN NUMBER) ISBEGINUPDATE PLAYER_BAT_STATSET AT_BATS = AT_BATS + V_AB,HITS = HITS + V_HITSWHERE PLAYER_ID=V_ID;COMMIT;VALIDATE_PLAYER_STAT(V_ID);END UPD_PLAYER_STAT;PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBERI) ISBEGININSERT INTO PLAYER (ID,LAST_NAME, SALARY)VALUES(V_ID,V_LAST_NAME,V_SALARY);UPD_PLAYER_STAT(V_ID,0,0);END ADD_PLAYER;END BB_PACK;If you add an IF statement to the ADD_PLAYER procedure which additional step must you perform?r A Recompile the ADD PLAYER procedureRecompile both the BB PACK specification and bodyS~
(A)Recompile the ADD_PLAYER procedure
(B)Recompile both the BB_PACK specification and body
(C)Recompile the BB_PACK specification
(D)Recompile the BB_PACK body

參考答案

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