What is a stored procedure in SQL? Discuss its purpose, how it differs from regular SQL statements, and when it is beneficial to use them.
The interviewer expects a clear explanation of what stored procedures are, their advantages, and examples of scenarios where they are particularly useful.