The contents of sys.dm_os_wait_stats can be reset by running which of the following command?

A)  DBCC SQLP (‘sys.dm_os_wait_stats’, CLEAR);
B)  DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);
C)  DBCC PERF (‘sys.dm_os_wait_stats’, CLEAR);
D)  None of the above

Correct Answer :   DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);

Explanation : DBCC SQLPERFcommand resets all counters to 0.

Top Trending Technologies MCQ's
Machine Learning
Artificial Intelligence
IOT QUIZ
Blockchain
Deep Learning
Data Science
Keras
DevOps
Cyber Security
Ethical Hacking
Microsoft Azure
AWS
Cloud Computing
Quantum Computing
Edge Computing
ChatGPT
RPA
5G Network
Data Analytics
Neural Networks
Natural Language Processing
Networking
Virtual Reality
Augmented Reality
Angular
Node JS
React JS
C-Language
Java
More
Top Trending Technologies Interview Questions
Machine Learning
Artificial Intelligence
IOT QUIZ
Blockchain
Deep Learning
Data Science
LLM
ChatGPT
Metaverse
DevOps
Cyber Security
Ethical Hacking
HyperAutomation
Microsoft Azure
AWS
Cloud Computing
Quantum Computing
Edge Computing
Cognitive Computing
RPA
5G Network
Checkpoint
Neural Networks
Virtual Reality
Augmented Reality
Full Stack Developer
Web Services
Angular
Node JS
React JS
C-Language
CPP (or) C++
More