Full-stack dev quiz question #23

Full-stack dev quiz question #23

quizDo you have any idea what DBCC FREEPROCCACHE does? Check it out in the twenty third question of the quiz for a full-stack developer.

 

 

Which statement best describes what DBCC FREEPROCCACHE does in SQL Server?

Choose the best answers:

  1. It prints statistics of the cache usage.
  2. It cleans processor cache.
  3. It returns size of available cache in the memory.
  4. It scans the current database for errors in the free cache area.
  5. It removes execution plans from the cache.

For the correct answer scroll down

.

.

.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

.

.

.

The correct answer is e: it removes execution plans from the cache. For more information check Clean SQL Server cache.

If you like what I do, consider buying me a coffee :)

Buy me a coffeeBuy me a coffee