nerdexam
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)
  • A
    7% (2)
  • B
    75% (21)
  • C
    14% (4)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-147 Practice