5. What are SQL triggers, and when would you use them in a database? Provide an example scenario where a trigger could be beneficial.

SQL triggers are special types of stored procedures that are defined to execute automatically in response to certain events on a particular table or view in a database. They are typically used to maintain the integrity of the information on the database.

Triggers can be beneficial in several scenarios. For example, let's consider a banking application where we have a table called ACCOUNTS. This table has a column called BALANCE which stores the balance amount of each account.

Now, let's say we want to ensure that the BALANCE column never falls below 0. We can create a trigger on the ACCOUNTS table that automatically checks the BALANCE column after each UPDATE operation. If the BALANCE is less than 0, the trigger can rollback the transaction, ensuring that the BALANCE never falls below 0.

Here is a simple example of how such a trigger could be defined:

CREATE TRIGGER check_balance
AFTER UPDATE ON accounts
FOR EACH ROW
BEGIN
   IF NEW.balance < 0 THEN
      ROLLBACK;
   END IF;
END;

In this example, check_balance is the name of the trigger, accounts is the name of the table on which the trigger is defined, NEW.balance refers to the updated value of the BALANCE column, and ROLLBACK is the SQL command to undo the transaction.

So, in summary, SQL triggers are useful tools for maintaining the integrity of the data in a database, and they can be used to automatically enforce business rules and constraints.