Pergunta de entrevista da empresa Bottomline

What is a trigger in SQL and why would you use it?