SQL MCQ Set 1 1. Which of the following requires VIEW SERVER STATE permission on the server ? a) sys.dm_os_states b) sys.dm_os_wait_stats c) sys.dm_os_wait_states d) None of the mentioned AnswerAnswer: b [Reason:] sys.dm_os_wait_stats returns information about all the waits encountered by threads that executed. 2. Point out the correct statement : a) 510: CXPACKET indicates…
This content is for paid premium members only.
You can view complete answer after activation your membership.
Need only one answers. Simply buy single day pass and email. We will send answers for this question.
Login Buy membership