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

You need to create a trigger to ensure that information in the EMP table is only modified during business hours, Monday to Friday from 9:00am to 500pm Which types of trigger do you create? (Choose two.)

• A.statement level AFTER INSERT OR UPDATE OR DELETE ON EMP
• B.row level AFTER INSERT OR UPDATE OR DELETE ON EMP
• C.row level BEFORE INSERT OR UPDATE OR DELETE ON EMP
• D.statement level BEFORE INSERT OR UPDATE OR DELETE ON EMP

Which statements are true? (Choose all that apply)

• A.If errors occur during the compilation of a trigger, the trigger is still created.
• B.If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_TRIGGERS data dictionary view to see the compilation errors.
• C.If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL *Plus to see the compilation errors.
• D.If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_ERRORS data dictionary view to see compilation errors.

When creating stored procedures and functions, which construct allows you to transfer values to and from the calling environment?

• A.arguments
• B.local variables
• C.Boolean variables
• D.Substitution variables

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

Examine this package:
CREATE OR REPLACE PACKAGE BB_PACK IS
V_MAX_TEAM_SALARY NUMBER(12,2);
PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY
NUMBER);
END BB_PACK;
/
CREATE OR REPLACE PACKAGE BODY BB_PACK
IS
PROCEDURE UPD_PLAYER_STAT
(V_ID IN NUMBER, V_AB IN NUMBER DEFAULT 4, V_HITS IN NUMBER)
IS
BEGIN
UPDATE PLAYER_BAT_STAT
SET AT_BATS = AT_BATS + V_AB,
HITS = HITS + V_HITS
WHERE PLAYER_ID = V_ID;
COMMIT;
END UPD_PLAYER_STAT;
PROCEDURE ADD_PLAYER
(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER)
IS
BEGIN
INSERT INTO PLAYER(ID,LAST_NAME,SALARY)
VALUES (V_ID, V_LAST_NAME, V_SALARY);
UPD_PLAYER_STAT(V_ID,0,0);
END ADD_PLAYER;
END BB_PACK;
You make a change to the body of the BB_PACK package. The BB_PACK body is recompiled.
What happens if the stand alone procedure VALIDATE_PLAYER_STAT references this package?

• A.VALIDATE_PLAYER_STAT is not invalidated.
• B.VALIDATE_PLAYER_STAT and BB_PACK are invalidated.
• C.VALDIATE_PLAYER_STAT is invalidated.
• D.VALIDATE_PLAYER_STAT cannot recompile and must be recreated.