C valdiateplayerstat is invalidated d

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ER_STAT is not invalidated. C. VALDIATE_PLAYER_STAT is invalidated. D. VALIDATE_PLAYER_STAT and BB_PACK are invalidated. Answer: B You can greatly simplify dependency management with packages when referencing a package procedure or function from a stand-alone procedure or function. • If the package body changes and the package specification does not change, the stand-alone procedure referencing a package construct remains valid. • If the package specification changes, the outside procedure referencing a package construct is invalidated, as is the package body. QUESTION 12: You need to create a trigger on the EMP table that monitors every row that is changed and places this information into the AUDIT_TABLE. What type of trigger do you create? A. FOR EACH ROW trigger on the EMP table. B. Statement-level trigger on the EMP table. C. FOR EACH ROW trigger on the AUDIT_TABLE table. D. Statement-level trigger on the AUDIT_TABLE table. E. FOR EACH ROW statement-level trigger on the EMPtable. Answer: A Explanation: A FOR EACH ROW trigger on the EMP table will fire for each row that is modified in the employee table and will insert a record in the AUDIT_TABLE for each corresponding row modified in the EMP Table. A Statement-level trigger will only fire once and could only be used to insert a single row into the AUTIT_TABLE. Incorrect Answers B: Would only insert one row into the AUDIT_TABLE and could not reference the :OLD &: NEW qualifies. Therefore you could not track the changes made to the EMP Columns, you could only log that an update was performed on the table. Actualtests.com - The Power of Knowing 1Z0-147 C: The trigger should be based on the UPDATE Event of the EMP Table. D: Incorrect Trigger Type on the wrong table E: Incorrect Trigger Type QUESTION 13: 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 v...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online