Question

Which trigger updates the customer balance when an invoice is deleted?

A) Trigger trg_updatecustbalance1
B) Trigger trg_updatecustbalance2
C) Trigger inv_delete_custbalance
D) Trigger inv_update_custbalance

Answer 1

The trigger 'inv_delete_custbalance' updates the customer balance when an invoice is deleted.

Step-by-step explanation:

The correct trigger that updates the customer balance when an invoice is deleted is Trigger inv_delete_custbalance. This trigger is specifically designed to be executed when an invoice is deleted and it is responsible for updating the customer balance accordingly.