MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 7. |
How many types of wait occur in SQL Server ? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 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 | |