Question

Which of the following commands is used to create a trigger in SQLite?

a) CREATE TRIGGER

b) ADD TRIGGER

c) ALTER TRIGGER

d) MODIFY TRIGGER

Answer 1

Answer: a) CREATE TRIGGER

Explanation: The CREATE TRIGGER statement is used to create a trigger in SQLite. The syntax is as follows: CREATE TRIGGER trigger_name BEFORE/AFTER INSERT/UPDATE/DELETE ON table_name FOR EACH ROW BEGIN … END;