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 59 Local procedure A calls remote procedure B.Procedure B was compiled at 8 A.M. Procedure A was modified and recompiled at 9A.M. Remote procedure B was later modified and recompiled at 11 A.M. The dependency mode is set to TIMESTAMP. What happens when procedure A is invoked at 1 P.M? Long (A) There is no affect on procedure A and it runs successfully. (B) Procedure B is invalidated and recompiles when invoked. (C) Procedure A is invalidated and recompiles for the first time it is invoked. (D) Procedure A is invalidated and recompiles for the second time it is invoked.

複選題QUESTION 60 Under which two circumstances do you design database triggers? (Choose two) to for (A) To duplicate the functionality of other triggers. (B) To replicate built-in constraints in the Oracle server such as primary key and foreign key. (C) To guarantee that when a specific operation is performed, related actions are performed. (D) For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement.

QUESTION 61 Examine this procedure: CREATE OR REPLACE PROCEDURE DELETE_PLAYER (V_ID IN NUMBER) IS BEGIN DELETE FROM PLAYER WHERE ID = V_ID; EXCEPTION WHEN STATS_EXITS_EXCEPTION THEN DBMS_OUTPUT.PUT_LINE ('Cannot delete this player, child records exist in PLAYER_BAT_STAT table'); END; What prevents this procedure from being created successfully? L (A) A comma has been left after the STATS_EXIST_EXCEPTION exception. (B) The STATS_EXIST_EXCEPTION has not been declared as a number. (C) The STATS_EXIST_EXCEPTION has not been declared as an exception. (D) Only predefined exceptions are allowed in the EXCEPTION section.

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 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 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 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