Multiple choice technology databases

Stored procedures are compiled the first time they’re run but are not stored in a system table of the current database.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The statement is false because stored procedures ARE stored in system tables of the current database after compilation. When first executed, a stored procedure is compiled and its execution plan is cached in system tables (like syscomments in some systems) for reuse. This caching improves performance on subsequent executions.