Bottomline interview question

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