What is a condition predicate in a DML trigger?

What is a condition predicate in a DML trigger?

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 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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


khushboo

khushboo

Option C is the answer