Which type of trigger is suitable for generating an inventory report after an inventory count update?

• A. BEFORE INSERT
• B. BATCH TRIGGER
• C. AFTER UPDATE
• D. BEFORE UPDATE

Answer: (C)

The suitable type of trigger for generating an inventory report after an inventory count update is the AFTER UPDATE trigger. This type of trigger is designed to execute a specified action following the successful completion of an update on a table.

In the context of generating an inventory report, using an AFTER UPDATE trigger allows the system to ensure that the inventory count has already been modified before attempting to generate the report. This sequence is critical because if the action were to happen before the update, the report would still reflect the old data, thereby providing inaccurate information.

Other options do not align with the requirement for post-update actions. BEFORE INSERT and BEFORE UPDATE triggers execute their actions before the specified change happens, which means they would not be able to capture the new state of the inventory count necessary for an accurate report. A BATCH TRIGGER, while useful for handling bulk operations, is not specifically intended for individual row updates and does not fulfill the need for generating a report after an update. Therefore, the AFTER UPDATE trigger is the most appropriate choice for this scenario.