gs gs116 Monitoring and Auditing - SQL Server Wait States - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Monitoring and Auditing. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following requires VIEW SERVER STATE permission on the server?
sys.dm_os_states
sys.dm_os_wait_stats
sys.dm_os_wait_states
none of the mentioned
Question 2: Point out the correct statement.
510: CXPACKET indicates parallelism
SQL Server does not always waits for something, a disk io, a place in the processor queue, a lock
Few variations of PAGEIOLATCH waits usually indicate a problem with the disk subsystem
All of the mentioned
Question 4: The contents of sys.dm_os_wait_stats can be reset by running which of the following command?
DBCC PERF (‘sys.dm_os_wait_stats’, CLEAR);
DBCC SQLP (‘sys.dm_os_wait_stats’, CLEAR);
DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);
None of the mentioned
Question 5: Point out the wrong statement.
LCK_M_XX wait is often a symptom of blocking
PAGELATCH_XX wait occurs when SQL Server is attempting to latch a page in memory
Few variations of PAGEIOLATCH waits usually indicate a problem with the disk subsystem
All of the mentioned
Question 7: Which of the following wait occurs when a task is waiting for I/Os to finish?
ASYNC_NETWORK_IO
AUDIT_LOGINCACHE_LOCK
AUDIT_ON_DEMAND_TARGET_LOCK
AUDIT_XE_SESSION_MGR
Question 8: When does BROKER_TO_FLUSH wait type event occur?
When the Service Broker queue task handler tries to shut down the task
When the Service Broker transmitter is waiting for work
When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table
All of the mentioned
Question 9: Which of the following wait type is for internal use only?
ASYNC_NETWORK_IO
AUDIT_LOGINCACHE_LOCK
HADR_DBR_SUBSCRIBER_FILTER_LIST
AUDIT_XE_SESSION_MGR
Question 10: _____________ wait type applies to SQL Server 2014 only.
LCK_M_U_ABORT_BLOCKERS
HADR_WORK_QUEUE
HADR_XRF_STACK_ACCESS
HADR_WORK_POOL
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
