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. Choose the appropriate one.
Options
- Trigger
- Stored Procedure
- Transact-SQL statements
- Trigger and Stored Procedure
CORRECT ANSWER : Trigger and Stored Procedure
Write your comments