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 ?
A. DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ]
B. DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ]
C. DBCC FREEPROCCACHE [ ( { sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ]
D. None of the mentioned
Answer:A
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 ?
A. DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ] B. DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ] C. DBCC FREEPROCCACHE [ ( { sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ] D. None of the mentioned
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.