QUESTION 73 Examine the trigger heading: CREATE OR REPLACE TRIGGER salary_check BEFORE UPDATE OF sal, job ON emp FOR EACH ROW Under which condition does this trigger fire?
(A) When a row is inserted into the EMP table.
(B) When the value of the SAL or JOB column in a row is updated in the EMP table.
(C) When any column other than the SAL and JOB columns in a row are updated in the EMP table.
(D) Only when both values of the SAL and JOB columns in a row are updated together in the EMP table.

QUESTION 69 When creating a function, in which section will you typically find the RETURN keyword? (A) HEADER only (B) DECLARATIVE (C) EXECUTABLE and HEADER (D) DECLARATIVE,EXECUTABLE and EXCEPTION HANDLING

QUESTION 70 A dependent procedure or function directly or indirectly references one or more of which four objects? (Choose four) not CE 1. view 2. sequence 3. privilege 4. procedure 5. anonymous block 6. packaged procedure or function (A)1234(B)2345(C)1246(D)3456

複選題QUESTION 71 Which three are true regarding error propagation? (Choose three) no block (A) An exception cannot propagate across remote procedure calls. (B) An exception raised inside a declaration immediately propagates to the current block. (C) The use of the RAISE; statement in an exception handler reprises the current exception. (D) An exception raised inside an exception handler immediately propagates to the enclosing block.

複選題QUESTION 72 Which two tables or views track object dependencies? (Choose two) (A) USER_DEPENDENCIES (B) USER_IDEPTREE (C) IDEPTREE (D) USER_DEPTREE (E) USER_DEPENDS

QUESTION 74 You have an AFTER UPDATE row-level on the table EMP. The trigger queries the EMP table and inserts the updating user's information into the AUDIT_TABLE. What happens when the user updates rows on the EMP table? (A) A compile time error occurs. (B) A runtime error occurs. The effect of trigger body and the triggering statement are rolled back. (C) A runtime error occurs. The effect of trigger body is rolled back, but the update on the EMP table takes place. (D) The trigger fires successfully. The update on the EMP table occurs, and data is inserted into theAUDIT_TABLE table. (E) A runtime error occurs. The update on the EMP table does not take place, but the insert into the AUDIT_TABLE occurs.

QUESTION 75 The add_player, upd_player_stat, and upd_pitcher_stat procedures are grouped together in a package. A variable must be shared among only these procedures. Where should you declare this variable? (A) In the package body. (B) In a database trigger. (C) In the package specification. (D) In each procedure's DECLARE section, using the exact same name in each.

QUESTION 76 Examine this package: CREATE OR REPLACE PACKAGE pack_cur IS CURSOR c1 IS SELECT prodid FROM product ORDER BY Prodid DESC; PROCEDURE Proc1; PROCEDURE Proc2; END pack_cur; / CREATE OR REPLACE PACKAGE BODY pack_cur IS v_prodif NUMBER; PROCEDURE proc1 IS BEGIN OPEN C1; LOOP FETCH c1 INTO V_prodid; DBMS_OUTPUT.PUT_LINE('Row is ;'||C1% ROWCOUNT); EXIT WHEN C1% ROWCOUNT>=3; END LOOP; END PROC1; PROCEDURE proc2 IS BEGIN LOOP FETCH C1 INTO v_prodid; DBMS_OUTPUT-PUT_LINE ( ' Row is: ' ll c1 %ROWCOUNT); EXIT WHEN C1%ROWCOUNT >= 3; END LOOP; END Procl; / The product table has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. You execute the procedure PROC1 from SQL *Plus with the command: EXECUTE pack_cur. PROC1; You then execute the procedure PROC2 from SQL *Plus with the command: EXECUTE pack_cur. PROC2; What is the output in your session from the PROC2 procedure? (A) ERROR at line 1: (B) Row is: Row is: Rows is: (C) Row is: 1 Row is: 2 Row is: 3 (D) Row is: 4 Row is: 5 Row is: 6

QUESTION 77 You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to enable all triggers on the EMPLOYEES table. Which command accomplished this? (A) You cannot enable multiple triggers on a table in one command. (B) ALTER TRIGGERS ON TABLE employees ENABLE; (C) ALTER employees ENABLE ALL TRIGGERS; (D) ALTER TABLE employees ENABLE ALL TRIGGERS;

QUESTION 78 When creating stored procedures and functions, which construct allows you to transfer values to and from the calling environment? (A) local variables (B) arguments (C) Boolean variables (D) Substitution variables

QUESTION 79 You have the following table: CREATE TABLE Emp_log ( Emp_id NUMBER Log_date DATE, New_salary NUMBER, Action VARCHAR (20)); You have the following data in the EMPLOYEES table: EMPLOYEE_ID LAST_NAME SALARY DEPARTMENT_ID ----------- ------------------- ------------ ------------- 100 Bill 24000 90 101 Kochhar 17000 90 102 De Haan 17000 90 103 Hunold 9000 60 104 Ernst 6000 60 105 Austin 4800 60 106 Pataballa 4800 60 107 Lorentz 4200 60 108 Greenberg 12000 100 201 Hartstein 13000 20 202 Fay 6000 20 You create this trigger: CREATE OR REPLACE TRIGGER Log_salary_increase AFTER UPDATE ON employees FOR EACH ROW WHEN (new.Salary > 1000) BEGIN INSERT INTO Emp_log (Emp_id, Log_date, New_Salary, Action) VALUES (:new.Employee_id, SYSDATE, :new.SALary, 'NEW SAL'); END / Then, you enter the following SQL statement: UPDATE Employee SET Salary = Salary + 1000.0 Where Department_id = 20M What are the result in the EMP_LOG table? A EMP_ID LOG_DATE NEW_SALARY ACTION ---------- -------- ---------- ---------- 201 24-SEP-02 13000 NEW SAL 202 24-SEP-02 600 NEW SAL (B) EMP_ID LOG_DATE NEW_SALARY ACTION ---------- -------- ---------- ---------- 201 24-SEP-02 14000 NEW SAL 202 24-SEP-02 7000 NEW SAL (C) EMP_ID LOG_DATE NEW_SALARY ACTION ---------- -------- ---------- ---------- 201 24-SEP-02 NEW SAL 202 24-SEP-02 NEW SAL (D) No rows are inserted.