Question: Which of the following statements regarding SQL triggers and their functionality is correct?

A) A trigger is a stored procedure that runs automatically in response to specific events on a table, such as insertions, updates, or deletions.
B) Triggers can only be defined to execute before a data modification operation and cannot run after the operation is completed.
C) Triggers are designed to replace stored procedures and should be used for all data manipulation tasks within the database.
D) A trigger can be fired multiple times for a single operation if the operation affects multiple rows in the table.