Module 21: Transaction Processing

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.