A database trigger executes implicitly whenever a

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: atabase 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. Answer: A, C, D Explanation: 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. Incorrect Answers B. Database Triggers are invoked implicitly whenever a particular event occurs in the database. 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 trigger? A. DURING B. IN PLACE OF C. ON SHUTDOWN D. BEFORE E. ON STATEMENT EXECUTION Answer: D Explanation: Trigger Timing determines whether the trigger will fire BEFORE or AFTER the DML statement on the table. The BEFORE and AFTER timings are not valid for views. You can only create an INSTEAD OF trigger on a view. Incorrect Answers A, B, C & E are not valid Oracle Events QUESTION 77: Which two statements about the overloading feature of packages are true? (Choose two) 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....
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online