Stored Procedure vs. Database Trigger

Question 1

Distinguish between a stored procedure and a database trigger.

Answer 1

Stored Procedure: A set of SQL statements that can be executed on demand. It is explicitly invoked by the application or user.
Database Trigger: A set of SQL statements that automatically execute in response to a specific event (e.g., INSERT, UPDATE, DELETE) on a specific table.