Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

WHICH_OF_THE_FOLLOWING_WAIT_TYPE_IS_FOR_INTERNAL_USE_ONLY_??$

A. ASYNC_NETWORK_IO
B. AUDIT_LOGINCACHE_LOCK
C. HADR_DBR_SUBSCRIBER_FILTER_LIST
D. AUDIT_XE_SESSION_MGR
Answer» D. AUDIT_XE_SESSION_MGR
Discussion
2.

______________wait_type_applies_to_SQL_Server_2014_only.$

A. LCK_M_U_ABORT_BLOCKERS
B. HADR_WORK_QUEUE
C. HADR_XRF_STACK_ACCESS
D. HADR_WORK_POOL
Answer» B. HADR_WORK_QUEUE
Discussion
3.

When does BROKER_TO_FLUSH wait type event occurs ?

A. When the Service Broker queue task handler tries to shut down the task
B. When the Service Broker transmitter is waiting for work
C. When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table
D. All of the mentioned
Answer» D. All of the mentioned
Discussion
4.

Which of the following wait occurs when a task is waiting for I/Os to finish ?

A. ASYNC_NETWORK_IO
B. AUDIT_LOGINCACHE_LOCK
C. AUDIT_ON_DEMAND_TARGET_LOCK
D. AUDIT_XE_SESSION_MGR
Answer» B. AUDIT_LOGINCACHE_LOCK
Discussion
5.

______ waits occur when a worker requests access to a resource that is not available because the resource is being used by some other worker or is not yet available.

A. Resource
B. Queue
C. Lock
D. External
Answer» B. Queue
Discussion
6.

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

A. DBCC PERF (‘sys.dm_os_wait_stats’, CLEAR);
B. DBCC SQLP (‘sys.dm_os_wait_stats’, CLEAR);
C. DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
7.

How many types of wait occur in SQL Server ?

A. 2
B. 3
C. 4
D. 5
Answer» C. 4
Discussion
8.

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
Answer» C. sys.dm_os_wait_states
Discussion