Oracle
1Z0-147 · Question #2
Examine this procedure: CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID,LAST_NAME) VALUES (V_ID, V_LAST_NAME); COMMIT; END; This…
The correct answer is B. UPD_BAT_STAT(V_ID). See the full explanation below for the reasoning.
Question
Examine this procedure:
CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID,LAST_NAME) VALUES (V_ID, V_LAST_NAME); COMMIT; END;
This procedure must invoke the UPD_BAT_STAT procedure and pass a parameter. Which statement, when added to the above procedure, will successfully invoke the UPD_BAT_STAT procedure?
Options
- AEXECUTE UPD_BAT_STAT(V_ID);
- BUPD_BAT_STAT(V_ID);
- CRUN UPD_BAT_STAT(V_ID);
- DSTART UPD_BAT_STAT(V_ID);
How the community answered
(28 responses)- A7% (2)
- B75% (21)
- C14% (4)
- D4% (1)
Community Discussion
No community discussion yet for this question.