問題詳情

QUESTION 13Examine 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, V_SALARY_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;Which statement will successfully assign $75,000,000 to the V_MAX_TEAM_SALARY variable from within a stand-alone procedure?
(A)V_MAX_TEAM_SALARY := 7500000;
(B)BB_PACK.ADD_PLAYER.V_MAX_TEAM_SALARY := 75000000;
(C)BB_PACK.V_MAX_TEAM_SALARY := 75000000;
(D)This variable cannot be assigned a value from outside the package.

參考答案

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