Quiz for Triggers

Q1: What is a trigger in SQL?

A. A special view B. A stored query C. A function called manually D. A procedure automatically invoked by events

Q2: Which SQL statements can activate a trigger?

A. SELECT, INSERT B. INSERT, UPDATE, DELETE C. DROP, ALTER D. TRUNCATE, GRANT

Q3: When does a BEFORE trigger execute?

A. After the action is completed B. Before the action is completed C. During the action D. At compile time

Q4: Can a trigger call a stored procedure?

A. Yes B. No C. Only in MySQL D. Only for AFTER triggers

Q5: Which keyword is used to define a trigger in SQL?

A. DEFINE B. CREATE TRIGGER C. SET TRIGGER D. ADD TRIGGER

Q6: Which clause specifies the timing of a trigger?

A. WHEN B. TIME C. BEFORE or AFTER D. START

Q7: What does the OLD keyword refer to in triggers?

A. The previous row value B. The new row value C. The schema D. A temporary table

Q8: What does the NEW keyword refer to?

A. The updated database B. The entire database C. The new row value D. The current schema

Q9: Can a trigger modify the same table it’s triggered on?

A. Always B. Never C. Depends on the DBMS D. Only in AFTER triggers

Q10: Which of these cannot be used inside a trigger?

A. INSERT B. UPDATE C. COMMIT D. SELECT

Q11: How many triggers can be applied to a single table?

A. Only one B. Unlimited C. One per operation D. Two per operation

Q12: Which type of trigger prevents invalid data from being inserted?

A. AFTER trigger B. BEFORE trigger C. ROW trigger D. STATEMENT trigger

Q13: Which type of trigger operates on each affected row?

A. ROW trigger B. STATEMENT trigger C. TABLE trigger D. COLUMN trigger

Q14: Which type of trigger executes once per SQL statement?

A. ROW trigger B. BEFORE trigger C. STATEMENT trigger D. ACTION trigger

Q15: Can triggers be disabled temporarily?

A. Yes B. No C. Only in Oracle D. Only in MySQL

Q16: Which system table stores trigger definitions in SQL Server?

A. sys.triggers B. sysobjects C. sys.tables D. trigger_list

Q17: What happens if a trigger fails during execution?

A. The operation still proceeds B. Only warning is raised C. The entire operation is rolled back D. It retries automatically

Q18: Which clause specifies the event in a trigger?

A. AFTER B. WHEN C. ON INSERT/UPDATE/DELETE D. FOR EACH

Q19: Can a trigger be created on a view?

A. Yes B. No C. Only in PostgreSQL D. Only on materialized views

Q20: Why are triggers used?

A. To enforce business rules automatically B. To store data C. To improve performance D. To normalize schema