Quiz for BEFORE vs AFTER Trigger

Q1: What is the difference between BEFORE and AFTER triggers?

A. BEFORE runs after action; AFTER runs before B. BEFORE runs before the DML operation; AFTER runs after it C. AFTER is deprecated D. They are the same

Q2: Which trigger type allows modification of NEW values before insertion?

A. BEFORE INSERT B. AFTER INSERT C. BEFORE DELETE D. AFTER UPDATE

Q3: Which trigger cannot modify data in the table that caused the trigger to fire?

A. BEFORE trigger B. AFTER trigger C. INSTEAD OF trigger D. None of the above

Q4: Which is true about a BEFORE trigger?

A. It fires after the DML operation B. It cannot be used to validate data C. It fires before the DML operation D. It is executed once per session

Q5: Which of the following is executed last in an INSERT operation?

A. BEFORE INSERT trigger B. AFTER INSERT trigger C. Validation constraint D. Check constraint

Q6: Which trigger is best for logging actions that occurred?

A. BEFORE trigger B. AFTER trigger C. INSTEAD OF trigger D. SCHEDULED trigger

Q7: Which of these can be used to prevent invalid data from being inserted?

A. AFTER INSERT trigger B. BEFORE INSERT trigger C. AFTER UPDATE trigger D. SYNONYM

Q8: Which trigger allows you to update another table after a row is inserted?

A. BEFORE INSERT B. AFTER INSERT C. BEFORE DELETE D. BEFORE UPDATE

Q9: BEFORE DELETE triggers are typically used to:

A. Log data after deletion B. Archive data before deletion C. Send alerts post deletion D. Prevent insertions

Q10: AFTER UPDATE triggers execute:

A. Before the row is updated B. When a session ends C. After the row is updated D. Only on rollback

Q11: Can you modify the NEW value in an AFTER INSERT trigger?

A. Yes B. No C. Only on DELETE D. Only with privileges

Q12: In which situation would a BEFORE UPDATE trigger be used?

A. To log the changes made B. To send email after update C. To modify values before updating D. To reject updates after they occur

Q13: Which clause is necessary to specify trigger timing?

A. ON TABLE B. FOR EACH ROW C. BEFORE or AFTER D. WHEN

Q14: Can AFTER triggers be used to enforce business rules?

A. Yes B. No C. Only BEFORE triggers can D. Only in stored procedures

Q15: Which trigger allows checking constraints before executing DML?

A. AFTER INSERT B. BEFORE INSERT C. AFTER DELETE D. BEFORE DELETE

Q16: Which trigger fires after the data is physically removed from a table?

A. BEFORE DELETE B. AFTER DELETE C. INSTEAD OF DELETE D. LOGON trigger

Q17: When is a BEFORE UPDATE trigger executed?

A. After updating the row B. Before checking constraints C. Before updating the row D. After commit

Q18: Which of these triggers cannot be used to prevent DML operation?

A. BEFORE trigger B. AFTER trigger C. INSTEAD OF trigger D. NONE

Q19: What is a valid use case for AFTER DELETE?

A. Update another table B. Modify OLD values C. Prevent deletion D. Rollback changes

Q20: What happens if a BEFORE trigger fails?

A. DML continues B. DML is rolled back C. AFTER trigger runs anyway D. Trigger is ignored

Q21: Which clause specifies the timing in a trigger?

A. WHEN B. ORDER BY C. BEFORE/AFTER D. GROUP BY