Multiple choice

Tom is developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. When the user commit records, Forms displays the default informative message 'FRM-40400: Transaction complete: records applied and saved.' He wants to replace that with the message 'Records inserted:', 'Records updated:', 'Records deleted:', Which of the following triggers must be created to modify or to accomplish this?

  1. On-Message only

  2. Post-Commit and On-Message

  3. Post-Database-Commit and On-Message

  4. Post-Insert, Post-Update, Post-Delete, and On-Message

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To replace the default Forms message with specific counts for insert/update/delete operations, you need Post-Insert, Post-Update, and Post-Delete triggers to capture counts after each operation type, plus an On-Message trigger to intercept and replace the FRM-40400 message. Post-Database-Commit fires too late (after transaction completes), and Post-Commit doesn't distinguish between operation types.

Keep practicing — related questions