Understanding Database Triggers

What is a database trigger?

• A) A table in a database

• B) A procedural SQL code executed automatically upon a data manipulation event

• C) A type of stored procedure executed manually

• D) A query that retrieves data

Which event can activate a database trigger?

• A) Running a SELECT statement

• B) Deleting a database

• C) Inserting, updating, or deleting a row

• D) Creating a new database

What command is used to create a trigger in SQL Server?

• A) CREATE PROCEDURE

• B) CREATE FUNCTION

• C) CREATE TRIGGER

• D) CREATE EVENT

What is the function of a trigger in enforcing referential integrity?

• A) It prevents unauthorized schema changes

• B) It ensures that related records in multiple tables remain consistent

• C) It automatically backs up data

• D) It optimizes query performance

Which of the following is NOT a type of trigger?

• A) BEFORE trigger

• B) AFTER trigger

• C) INSTEAD OF trigger

• D) DURING trigger

What is the main advantage of using triggers?

• A) They can be executed manually

• B) They provide a way to enforce business rules automatically

• C) They are faster than stored procedures

• D) They can only be used for data retrieval

What is the main difference between BEFORE and AFTER triggers?

• A) BEFORE triggers execute before a transaction, while AFTER triggers execute after the transaction

• B) BEFORE triggers delete records, while AFTER triggers update records

• C) BEFORE triggers can only be used in MySQL, while AFTER triggers are for SQL Server

• D) There is no difference between the two

7. What keyword is used to access newly inserted values inside a trigger in MySQL?

• A) INSERTED

• B) UPDATED

• C) NEW

• D) OLD

In SQL Server, which pseudo-tables store new and old values in an update trigger?

• A) UPDATED and NEW

• B) INSERTED and DELETED

• C) OLD and NEW

• D) BEFORE and AFTER

What is the purpose of the DECLARE statement inside a trigger?

• A) To declare local variables within the trigger

• B) To define table columns

• C) To specify the trigger execution time

• D) To delete table data