問題詳情

QUESTION 35Examine 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_PACKISV_PLAYER_AVG NUMBER(4,3);PROCEDURE UPD_PLAYER_STATV_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 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 .333 to the V_PLAYER_AVG variable from a procedure outside the package?333 long
(A)V_PLAYER_AVG := .333;
(B)BB_PACK.UPD_PLAYER_STAT.V_PLAYER_AVG := .333;
(C)BB_PACK.V_PLAYER_AVG := .333;
(D)This variable cannot be assigned a value from outside of the package.

參考答案

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