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 APD_BAT_STAT procedure and pass a parameter. Which statement, when added to the above procedure will successfully invoke the UPD_BAT_STAT procedure?

technology databases

  1. EXECUTE UPD_BAT_STAT(V_ID);

  2. UPD_BAT_STAT(V_ID);

  3. RUN UPD_BAT_STAT(V_ID);

  4. START UPD_BAT_STAT(V_ID);

Show answer
Correct Option: B

AI Explanation

To successfully invoke the UPD_BAT_STAT procedure within the ADD_PLAYER procedure, the correct statement to add is:

B. UPD_BAT_STAT(V_ID);

Explanation: In PL/SQL, to invoke a procedure, you simply write the procedure name followed by the parameter values enclosed in parentheses. Therefore, the correct syntax to invoke the UPD_BAT_STAT procedure with the parameter V_ID is UPD_BAT_STAT(V_ID).

Option A (EXECUTE UPD_BAT_STAT(V_ID)) is incorrect because the EXECUTE keyword is not required when invoking a procedure.

Option C (RUN UPD_BAT_STAT(V_ID)) is incorrect because the RUN keyword is not used to invoke a procedure in PL/SQL.

Option D (START UPD_BAT_STAT(V_ID)) is incorrect because the START keyword is not used to invoke a procedure in PL/SQL.

Therefore, the correct answer is B. UPD_BAT_STAT(V_ID).

Find more quizzes: