Multiple choice technology databases

Examine this procedure: CREATE OR REPLACE PROCEDURE INSERT_TEAM (V_ID in NUMBER, V_CITY in VARCHAR2 DEFAULT ‘AUSTIN’, V_NAME in VARCHAR2) IS BEGIN INSERT INTO TEAM (id, city, name) VALUES (v_id, v_city, v_name); COMMIT; END Which two statements will successfully invoke this procedure in SQL *Plus?

  1. EXECUTE INSERT_TEAM;

  2. EXECUTE INSERT_TEAM(3, V_NAME=>’LONGHORNS’, V_CITY=>’AUSTIN’);

  3. EXECUTE INSERT_TEAM(3, ‘AUSTIN’,’LONGHORNS’);

  4. EXECUTE INSERT_TEAM (V_ID := V_NAME := ‘LONGHORNS’, V_CITY :=‘AUSTIN’);
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

Option B uses named notation with the EXECUTE command (SQL*Plus syntax), and Option C uses positional notation with EXECUTE. Option A fails because the first parameter V_ID is required (no DEFAULT). Option D uses incorrect assignment syntax (:= instead of => for named parameters in SQL*Plus).

Keep practicing — related questions