Explanation:DBCC FREEPROCCACHE removes all elements from the plan cache, removes a specific plan from the plan cache by specifying a plan handle or SQL handle, or removes all cache entries associated with a specified resource pool. 10. _________ uniquely identifies a query plan for a batch that has executed and whose plan resides in the plan cache.
A. pool_name
B. plan_handle
C. sql_handle
D. None of the mentioned
Answer:A
Explanation:DBCC FREEPROCCACHE removes all elements from the plan cache, removes a specific plan from the plan cache by specifying a plan handle or SQL handle, or removes all cache entries associated with a specified resource pool. 10. _________ uniquely identifies a query plan for a batch that has executed and whose plan resides in the plan cache.
A. pool_name B. plan_handle C. sql_handle D. None of the mentioned
Explanation:plan_handle is varbinary(64) and can be obtained from the various dynamic management objects. Sanfoundry Global Education & Learning Series – SQL Server.