What is a condition predicate in a DML trigger?
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.
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 OracleB. 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.