What are the triggers role in sql server.

Question

Hi...............

Ques : If delete any table in back-end then which type trigger will fire automatically ?.