They are stored separately and they are qualified

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: 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? - 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. Answer: C Explanation: 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. Incorrect Answers 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 conditional predicates. QUESTION 68: Examine this package specification: CREATE OR REPLACE PACKAGE concat_all IS v_string VARCHAR2(100); PROCEDURE combine (p_num_val NUMBER); PROCEDURE combine (p_date_val DATE); PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER); END concat_all; / Which overloaded COMBINE procedure declaration can be added to this...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online