MySQL - Triggers MCQ

MySQL – Triggers MCQ

1 / 25

1. What is a MySQL trigger?

A table

A database object that automates actions

A database schema

A database connection

2 / 25

2. Which type of trigger is executed before the triggering event in MySQL?

AFTER

BEFORE

INSTEAD OF

ON UPDATE

3 / 25

3. What type of actions can trigger events respond to in MySQL?

SELECT and INSERT

INSERT only

INSERT and DELETE

INSERT, UPDATE, and DELETE

4 / 25

4. How do you create a trigger in MySQL?

CREATE TRIGGER

CREATE ACTION

CREATE EVENT

CREATE FUNCTION

5 / 25

5. Which keyword is used to specify the trigger’s name when creating a MySQL trigger?

NAME

EVENT_NAME

TRIGGER

TRIGGER_NAME

6 / 25

6. What is the primary purpose of an AFTER trigger in MySQL?

To execute before the triggering event

To validate data before insertion

To execute after the triggering event

To prevent data modification

7 / 25

7. In MySQL triggers, what does the FOR EACH ROW clause indicate?

It defines the action to be triggered

It indicates that the trigger is row-level

It specifies the trigger's timing

It specifies the table name

8 / 25

8. Which MySQL statement is used to alter an existing trigger?

ALTER TRIGGER

MODIFY TRIGGER

ALTER EVENT

UPDATE TRIGGER

9 / 25

9. What is the role of the BEGIN and END keywords in a MySQL trigger?

They control the trigger's timing

They specify the triggering event

They enclose the SQL statements to be executed

They define the trigger's name

10 / 25

10. What is a typical use case for a BEFORE trigger in MySQL?

Logging changes

Validating data

Archiving data

Auditing actions

11 / 25

11. How can you view a list of all triggers in a MySQL database?

SHOW TABLE TRIGGERS

SHOW EVENTS

SHOW TRIGGERS

SHOW DATABASE TRIGGERS

12 / 25

12. What is the primary purpose of using triggers in a database?

To optimize query performance

To create tables

To automate actions in response to specific events

To establish network connections

13 / 25

13. What is the primary role of AFTER triggers in MySQL?

To validate data before insertion

To execute after the triggering event

To execute before the triggering event

To prevent data modification

14 / 25

14. Which keyword specifies the timing of a MySQL trigger?

BEFORE

TIMING

AFTER

15 / 25

15. In a MySQL trigger, what is the significance of the OLD and NEW aliases?

They define the trigger's name

They represent the past and future states of data

They indicate trigger type (OLD for BEFORE, NEW for AFTER)

They control the trigger's timing

16 / 25

16. What is the primary benefit of using triggers for audit logging in MySQL?

Simplifying query optimization

Automating the creation of new tables

Creating an audit trail for data changes

Preventing data modification

17 / 25

17. How do you disable a trigger temporarily in MySQL without deleting it?

SET TRIGGER STATUS

ALTER TRIGGER

DISABLE TRIGGER

DROP TRIGGER

18 / 25

18. What role does the FOR EACH ROW clause play in MySQL triggers?

It specifies the trigger's timing

It specifies the table name

It indicates that the trigger is row-level

It defines the action to be triggered

19 / 25

19. What type of event can trigger actions in MySQL?

Data modification events

UPDATE only

DELETE only

SELECT and INSERT

20 / 25

20. What is the primary benefit of using the BEFORE keyword in MySQL triggers?

It specifies the trigger's timing

It controls the triggering event

It enforces data integrity rules

It allows actions before a data modification event

21 / 25

21. Which SQL statement is used to delete a trigger in MySQL?

DROP TRIGGER

DISABLE TRIGGER

REMOVE TRIGGER

DELETE TRIGGER

22 / 25

22. What is a common use case for AFTER triggers in MySQL?

Validating data before insertion

Logging changes

Archiving data

Preventing data modification

23 / 25

23. Which best practice should be followed when working with triggers in MySQL?

Avoid documenting triggers

Keep triggers simple and easy to maintain

Test triggers in a production environment

Use complex logic within triggers

24 / 25

24. How can you enable a disabled trigger in MySQL?

ALTER TRIGGER STATUS

ENABLED TRIGGER

RESET TRIGGER STATUS

ENABLE TRIGGER

25 / 25

25. What is a primary benefit of using MySQL triggers for data validation?

Automating the creation of new tables

Enforcing data integrity rules

Preventing data modification

Simplifying query optimization

Your score is