MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
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» C. DBCC FREEPROCCACHE [ ( { sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ]. | |