Oracle
1Z0-147 · Question #2
1Z0-147 Question #2: Real Exam Question with Answer & Explanation
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);
Community Discussion
No community discussion yet for this question.