QUESTION 1Examine this package:CREATE OR REPLACE PACKAGE BB_PACKISV_MAX_TEAM_SALARY NUMBER(12,2);PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, NUMBER);END BB_PACK;/CREATE OR REPLACE PACKAGE BODY BB_PACKISPROCEDURE 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;END UPD_PLAYER_STAT;PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER) 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;You make a change to the body of the BB_PACK package. The BB_PACK body is recompiled.What happens if the stand alone procedure VALIDATE_PLAYER_STAT references this package?
(A)VALIDATE_PLAYER_STAT cannot recompile and must be recreated.
(B)VALIDATE_PLAYER_STAT is not invalidated.
(C)VALDIATE_PLAYER_STAT is invalidated.
(D)VALIDATE_PLAYER_STAT and BB_PACK are invalidated.