Why triggers are needed in SQL - Quick Recap

Recall & Review

beginner

What is a trigger in a database?

A trigger is a special kind of stored procedure that automatically runs when certain events happen in the database, like inserting, updating, or deleting data.

beginner

Why do we need triggers in databases?

Triggers help automate tasks, keep data consistent, enforce rules, and react to changes without needing manual intervention.

beginner

Give an example of a situation where a trigger is useful.

For example, when a new order is added, a trigger can automatically update the stock quantity so the data stays accurate.

intermediate

How do triggers help maintain data integrity?

Triggers can check or change data automatically when it is added or changed, making sure the data follows the rules set by the database.

intermediate

Can triggers replace application code for some tasks? Why or why not?

Yes, triggers can handle some tasks inside the database itself, reducing the need for extra code in applications and ensuring rules are always followed.

What event can cause a trigger to run?

A Inserting data into a table

B Opening a database connection

C Running a SELECT query

D Closing the database

Triggers run automatically when data changes, like inserting, updating, or deleting rows.

Which of these is a main reason to use triggers?

A To automate repetitive tasks in the database

B To speed up SELECT queries

C To create user interfaces

D To store large files

Triggers automate tasks like updating related data or enforcing rules when data changes.

Triggers help keep data consistent by:

A Encrypting data on disk

B Backing up the database every hour

C Automatically checking or updating data when changes happen

D Allowing multiple users to edit the same data simultaneously

Triggers run code to check or fix data automatically when it is inserted, updated, or deleted.

When is a trigger NOT useful?

A For logging changes to data

B For automatically updating related tables

C For enforcing business rules inside the database

D For creating reports from data

Triggers do not create reports; they react to data changes.

Triggers run:

A Manually by the user

B Automatically when specific data events occur

C Only during database backups

D Only when the database starts

Triggers run automatically when data is inserted, updated, or deleted.

Explain in your own words why triggers are important in databases.

Think about how triggers help keep data correct without extra effort.

Describe a real-life example where a trigger could help manage data automatically.

Consider situations like updating stock after a sale or logging changes.