Multiple choice technology programming languages

Examine this procedure: CREATE OR REPLACE PROCEDURE UPD_BAT_STAT (V_ID IN NUMBER DEFAULT 10, V_AB IN NUMBER DEFAULT 4) IS BEGIN UPDATE PLAYER_BAT_STAT SET AT_BATS = AT_BATS + V_AB WHERE PLAYER_ID = V_ID; COMMIT; END; Which two statements will successfully invoke this procedure in SQL *Plus? (Choose two)

  1. a) EXECUTE UPD_BAT_STAT;

  2. b) EXECUTE UPD_BAT_STAT(V_AB=>10, V_ID=>31);

  3. c) EXECUTE UPD_BAT_STAT(31, 'FOUR', 'TWO');

  4. d) UPD_BAT_STAT(V_AB=>10, V_ID=>31);

  5. e) RUN UPD_BAT_STAT;
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

The procedure has default values (V_ID=10, V_AB=4). Option A works because defaults apply. Option B works using named notation with explicit values. Option C fails because it passes 3 arguments (string literals) to a 2-parameter procedure expecting NUMBER types. Option D fails because 'UPD_BAT_STAT' without EXECUTE isn't valid SQL*Plus syntax. Option E fails because 'RUN' isn't valid SQL*Plus syntax for invoking procedures.

Keep practicing — related questions