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 :
A. An explicit call to sp_compile
B. Executing a stored procedure using the WITH COMPILE option.
C. Changes made to a table or view referenced by the query
D. All of the mentioned
Answer:A
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 :
A. An explicit call to sp_compile B. Executing a stored procedure using the WITH COMPILE option. C. Changes made to a table or view referenced by the query D. All of the mentioned
Explanation:ALTER TABLE and ALTER VIEW is used to made changes to the table. 9. What is the syntax for DBCC FREEPROCCACHE with all the optional parameters in T-SQL ?