C a runtime error occurs the effect of trigger body

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: 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 Actualtests.com - The Power of Knowing 1Z0-147 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. Answer: B Explanation: This results in a mutating table. A mutating table is a table against which a data manipulation statement has a corresponding trigger on the DML statement is reading from the same table. When a trigger encounters a mutating table, a runtime error occurs, the effects of the trigger body and triggering statement are rolled back, and control is returned to the user or application. Incorrect Answers A. This trigger will be created without any compilation errors. The error will not occur until runtime. C. The effects of the trigger body and triggering statement are rolled back D A runtime error occurs and both are rolled back E A runtime error occurs and both are rolled back QUESTION 85: 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. Answer: A Explanation: A You want to declare this variable in the package body before the procedures so that it may be shared among all of the procedure. If it was declared in the package specification it would be accessible outside of the package. Incorrect Answers B. If you declared it inside a trigger it could only be used by the trigger in which it was defined. C. Declaring the variable in the package specification would make this variable public. Actualtests.com - The Power of Knowing 1Z0-147 D. The vari...
View Full Document

Ask a homework question - tutors are online