SQLite – 18 – Triggers MCQ

SQLite – Triggers

1 / 15

1. What is a trigger in SQLite?

2 / 15

2. In SQLite, what is the primary purpose of a trigger?

3 / 15

3. What type of events can trigger execution be associated with in SQLite?

4 / 15

4. In SQLite, when does a trigger execute?

5 / 15

5. What is the primary use case for triggers in SQLite?

6 / 15

6. In SQLite, can you specify multiple triggers for the same event?

7 / 15

7. What is the purpose of the CREATE TRIGGER statement in SQLite?

8 / 15

8. In SQLite, what is the primary use case for BEFORE triggers?

9 / 15

9. In SQLite, can a trigger reference other tables or views?

10 / 15

10. What does the OLD and NEW aliases refer to in triggers in SQLite?

11 / 15

11. What happens when a trigger returns a non-NULL value in SQLite?

12 / 15

12. In SQLite, what is the purpose of the DROP TRIGGER statement?

13 / 15

13. In SQLite, can a trigger be recursive?

14 / 15

14. What is the primary use case for AFTER triggers in SQLite?

15 / 15

15. What is the primary use case for INSTEAD OF triggers in SQLite?

Your score is

0%