QUESTION 66 You create a DML trigger. For the timing information, which are valid with a DML trigger?
(A) DURING
(B) IN PLACE OF
(C) ON SHUTDOWN
(D) BEFORE
(E) ON STATEMENT EXECUTION

QUESTION 62 Examine this package: CREATE OR REPLACE PACKAGE manage_emps IS tax_rate CONSTANT NUMBER(5,2) := .28; v_id NUMBER; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER); PROCEDURE delete_emp; PROCEDURE update_emp; FUNCTION calc_tax (p_sal NUMBER) RETURN NUMBER; END manage_emps; / CREATE OR REPLACE PACKAGE BODY manage_emps IS PROCEDURE update_sal (p_raise_amt NUMBER) IS BEGIN UPDATE emp SET sal = (sal * p_raise_emt) + sal WHERE empno = v_id; END; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER) IS BEGIN INSERT INTO emp(empno, deptno, sal) VALYES(v_id, p_depntno, p_sal); END insert_emp; PROCEDURE delete_emp IS BEGIN DELETE FROM emp WHERE empno = v_id; END delete_emp; PROCEDURE update_emp IS v_sal NUMBER(10, 2); v_raise NUMBER(10, 2); BEGIN SELECT sal INTO v_sal FROM emp WHERE empno = v_id; IF v_sal < 500 THEN v_raise := .05; ELSIP v_sal < 1000 THEN v_raise := .07; ELSE v_raise := .04; END IF; update_sal(v_raise); END update_emp; FUNCTION calc_tax (p_sal NUMBER) RETURN NUMBER IS BEGIN RETURN p_sal * tax_rate; END calc_tax; END manage_emps; / How many public procedures are in the MANAGE_EMPS package? (A) One (B) Two (C) Three (D) Four (E) Five

QUESTION 63 Which command must you issue to allow users to access the UPD_TEAM_STAT trigger on the TEAM table? (A) GRANT SELECT, INSERT, UPDATE, DELETE ON TEAM TO PUBLIC; (B) GRANT SELECT,INSERT,UPDATE,DELETE ON UPD_TEAM_STAT TO PUBLIC; (C) GRANT EXECUTE ON TEAM TO PUBLIC (D) GRANT SELECT, EXECUTE ON TEAM, UPD_TEAM_STAT TO PUBLIC;

QUESTION 64 Examine this code: CREATE OR REPLACE PROCEDURE set_bonus (p_cutoff IN VARCHAR2 DEFAULT 'WEEKLY' p_employee_id IN employees_employee_id%TYPE p_salary IN employees_salary%TYPE, p_bonus_percent IN OUT NUMBER DEFAULT 1.5, p_margin OUT NUMBER DEFAULT 2, p_bonus_value OUT NUMBER) IS BEGIN UPDATE emp_bonus SET bonus_amount =(p_salary * p_bonus_percent)/p_margin WHERE employee_id = p_employee_id; END set_bonus; / You execute the CREATE PROCEDURE statement above and notice that it fails. What are two reasons why it fails? (Choose two) Is d~~ 1. The syntax of the UPDATE statement is incorrect. 2. You cannot update a table using a stored procedure. 3. The format parameter p_bonus_value is declared but is not used anywhere. 4. The formal parameter p_cutoff cannot have a DEFAULT clause. 5. The declaration of the format parameter p_margin cannot have a DEFAULT clause. 6. The declaration of the format parameter p_bonus_percent cannot have a DEFAULT clause. (A)12(B)23(C)34(D)56

複選題QUESTION 65 Which three statements are true regarding database triggers? (Choose three) acd (A) A database trigger is a PL/SQL block, C, or Java procedure associated with a table, view, schema, or the database. (B) A database trigger needs to be executed explicitly whenever a particular event takes place. (C) A database trigger executes implicitly whenever a particular event takes place. (D) A database trigger fires whenever a data event (such as DML) or system event (such as logon, shutdown) occurs on a schema or database. (E) With a schema, triggers fire for each event for all users; with a database, triggers fire for each event for that specific user.

複選題QUESTION 67 Which two statements about the overloading feature of packages are true? (Choose two) 頭尾 only over (A) Only local or packaged subprograms can be overloaded. (B) Overloading allows different functions with the same name that differ only in their return types. (C) Overloading allows different subprograms with the same number, type and order of parameters. (D) Overloading allows different subprograms with the same name and same number or type of parameters. (E) Overloading allows different subprograms with the same name, but different in either number, type or order of parameters.

複選題QUESTION 68 All users currently have the INSERT privilege on the PLAYER table. You only want your users to insert into this table using the ADD_PLAYTER procedure. Which two actions must you take? (Choose two) BE (A) CRANT SELECT ON ADD_PLAYER TO PUBLIC; (B) CRANT EXECTUE ON ADD_PLAYER TO PUBLIC; (C) CRANT INSERT ON PLAYER TO PUBLIC; (D) CRANT EXECTUE INSERT ON ADD_PLAYER TO PUBLIC; (E) REVOKE INSERT ON PLAYER FROM PUBLIC;

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