1Z0-147 무료 덤프문제 온라인 액세스

Which two statements about functions are true? (Choose two.)

• A.A function must have a return statement in its body to execute successfully
• B.A stored function that is called from a SOL statement can return a value of any PL/SOL variable data type
• C.A stored function increases efficiency of queries by performing functions on the server rather than in the application
• D.From SOL*Plus, a function can be executed by giving the command EXECUTE functionname;
• E.Client-side functions can be used in SOL statements

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?

• A.UPD_BAT_STAT(V_ID);
• B.RUN UPD_BAT_STAT(V_ID);
• C.EXECUTE UPD_BAT_STAT(V_ID);
• D.START UPD_BAT_STAT(V_ID);

A dependent procedure or function directly or indirectly references one or more of which four objects? (Choose four)

• A.procedure
• B.privilege
• C.packaged procedure or function
• D.view
• E.sequence
• F.anonymous block

Which type of argument passes a value from a procedure to the calling environment?

• A.IN
• B.OUT
• C.BOOLEAN
• D.VARCHAR2

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 (V_ID := V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
• B.EXECUTE INSERT_TEAM(3, 'AUSTIN','LONGHORNS');
• C.EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN');
• D.EXECUTE INSERT_TEAM;
• E.EXECUTE INSERT_TEAM (3, 'LONGHORNS');