Online Access Free 1Z0-147 Practice Test

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)

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

Examine this package:
CREATE OR REPLACE PACKAGE discounts
IS
g_id NUMBER := 7829;
discount_rate NUMBER := 0.00;
PROCEDURE display_price (p_price NUMBER);
END discounts;
/
CREATE OR REPLACE PACKAGE BODY discounts
IS
PROCEDURE display_price (p_price NUMBER)
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('Discounted '||
TO_CHAR(p_price*NVL(discount_rate, 1)));
END display_price;
BEGIN
discount_rate := 0.10;
END discounts;
/
Which statement is true?

• A.The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session.
• B.The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a session.
• C.The value of DISCOUNT_RATE always remains 0.00 in a session.
• D.The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked.

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)

• A.EXECUTE UPD_BAT_STAT(V_AB=>10, V_ID=>31);
• B.EXECUTE UPD_BAT_STAT;
• C.EXECUTE UPD_BAT_STAT(31, 'FOUR','TWO');
• D.RUN UPD_BAT_STAT;
• E.UPD_BAT_STAT(V_AB=>10, V_ID=>31);

Which view displays indirect dependencies, indenting each dependency?

• A.DEPTREE
• B.I_DEPT_TREE
• C.IDEPTREE
• D.INDENT_TREE

What is true about stored procedures?

• A.A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.
• B.A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification.
• C.A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters.
• D.A stored procedure must have at least one executable statement in the procedure body.