1Z0-147 practice - PrepKeys

Q1 Multiple choice

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? (Choose two.)

Select all that apply.

A
EXECUTE INSERT_TEAM;
B
EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN');
C
EXECUTE INSERT_TEAM(3,'AUSTIN','LONGHORNS');
D
EXECUTE INSERT_TEAM (V_ID := 3, V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
E
EXECUTE INSERT_TEAM (3,'LONGHORNS');