This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ER_STAT is not invalidated.
C. VALDIATE_PLAYER_STAT is invalidated.
D. VALIDATE_PLAYER_STAT and BB_PACK are invalidated.
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
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.
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.
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.
- Fall '09