Transaction Processing |
01. What are the characteristics of following commit triggers?
Characteristics of Commit Triggers
• Pre-Commit trigger : Fires once if form changes
• Pre- and Post DML Trigger: Fire for each record before or after DML
02. What are the common uses for following commit triggers?
Common Uses for Commit Triggers
• Pre-Commit: Check user authorization
• Pre-Delete: Implement foreign-key delete rule
• Pre-Insert: Generate sequence numbers
• Pre-Update: Implement foreign-key update rule
03. Write down the rules of DML Statements Issued During Commit Processing.
Rules:
• DML statements may fire database triggers.
• Forms uses and retrieves ROWID.
• The Update Changed Columns
• Locking statements are not issued.
04. What is array DML?
Array DML:
• Performs array inserts, updates, and deletes
• Vastly reduces network traffic
05. What is the effect of array DML on transactional triggers?
Effect of Array DML on Transactional Triggers:
With DML Array Size set to 1, the Pre-Insert, Pre-Update, and Pre-Delete triggers fire for each new, changed, and deleted record.
0 Comments