This preview shows page 1. Sign up to view the full content.
Unformatted text preview: atabase trigger needs to be executed explicitly whenever a particular event takes
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.
Answer: A, C, D
The trigger body is a PL/SQL block in which you can issue both SQL and PL/SQL
statements from the trigger body. You can also call a stored procedure or a Java
procedure from the trigger body. You can also invoke a procedure developed using
object-oriented languages, such as C.
C Triggers are invoked implicitly whenever a particular event occurs in the database.
Actualtests.com - The Power of Knowing 1Z0-147
D Database Triggers occur when a Data Event DM, DDL occurs or when system
events such as shutting down or starting up the database or a logon or logoff from the database.
B. Database Triggers are invoked implicitly whenever a particular event occurs in the
E. Triggers that are created at the database level fire for all the users, and triggers that are
created at the schema level fire only when the triggering event involves that schema.
QUESTION 76: You create a DML trigger. For the timing information, which are valid with a DML
B. IN PLACE OF
C. ON SHUTDOWN
E. ON STATEMENT EXECUTION
Trigger Timing determines whether the trigger will fire BEFORE or AFTER the DML
the table. The BEFORE and AFTER timings are not valid for views. You can only create
INSTEAD OF trigger on a view.
A, B, C & E are not valid Oracle Events
QUESTION 77: Which two statements about the overloading feature of packages are true? (Choose
A. Only local or packaged subprograms can be overloaded.
B. Overloading allows different functions with the same name that differ only in their
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09