Explanation:Auto-parametrization occurs when an instance of SQL Server tries to parametrize a Transact-SQL request by replacing some literals with parameters so that reuse of the resulting cached execution plan across multiple similar-looking requests is possible. 7. The maximum size for all caches is a function of the ________ size.
A. RAM
B. Buffer pool
C. Hard disk
D. None of the mentioned
Answer:A
Explanation:Auto-parametrization occurs when an instance of SQL Server tries to parametrize a Transact-SQL request by replacing some literals with parameters so that reuse of the resulting cached execution plan across multiple similar-looking requests is possible. 7. The maximum size for all caches is a function of the ________ size.
A. RAM B. Buffer pool C. Hard disk D. None of the mentioned
Explanation:The resource monitor and user threads can examine plans run concurrently to decrease the current cost for each unused execution plan. 8. The conditions that invalidate a plan include the following :