This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ay have stand-alone functions & procedures with the same name as a Packaged
program units. They are stored separately and they are qualified using the Package Name
when calling the Package Procedure or function.
QUESTION 67: What is a condition predicate in a DML trigger? Actualtests.com - The Power of Knowing 1Z0-147
A. A conditional predicate allows you to specify a WHEN-LOGGING-ON condition in
the trigger body.
B. A conditional predicate means you use the NEW and OLD qualifiers in the trigger
body as a condition.
C. A conditional predicate allows you to combine several DBM triggering events into
one in the trigger body.
D. A conditional predicate allows you to specify a SHUTDOWN or STARTUP condition
in the trigger body.
A trigger can fire for all three DML statements, INSERT, UPDATE, and DELETE.
You can create a single trigger that fires whenever any of the three events occur. You can
determine which one of the three DML statements caused the trigger to fire.
There three conditional predicates are INSERTING, UPDATING, and DELETING.
All three predicates are BOOLEAN values indicating a TRUE or FALSE value in
response to the triggering
event that fired the trigger. You can check these BOOLEAN values to control processing
within the trigger body.
A. This does not exist in Oracle
B. These have nothing to do with conditional predicates. The :OLD & :NEW qualifiers
are used in ROW level Triggers to reference the incoming data using the :NEW prefix
and refer to the data already in the database using the :OLD prefix.
D. These are System Events that can be used with triggers but they have no bearing on
QUESTION 68: Examine this package specification:
CREATE OR REPLACE PACKAGE concat_all
PROCEDURE combine (p_num_val NUMBER);
PROCEDURE combine (p_date_val DATE);
PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER);
Which overloaded COMBINE procedure declaration can be added to
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09