Directions:
When executed first, the source is compiled into an execution plan. When executed again before the execution plan is aged from memory, the SQL Server engine detects the existing plan and reuses it.

Question:
Choose the appropriate one?

Option A):
Trigger
Option B):
Transact-SQL statements
Option C):
Trigger and Stored Procedure
Option D):
Stored Procedure

Correct Answer is Option C):
Trigger and Stored Procedure