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_IS_A_SERVICE_BROKER_RELATED_DYNAMIC_MANAGEMENT_VIEW_??$

A. sys.dm_broker_activated
B. sys.dm_broker_activated_tasks
C. sys.dm_broker_tasks
D. dm_broker_activated_tasks
Answer» C. sys.dm_broker_tasks
Discussion
2.

Which_of_the_utility_is_used_for_reporting_issue_in_Service_Broker_?$

A. diagnose
B. ssiagnose
C. ssbdiagnose
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
3.

Which of the following change was introduced in SQL Server 2012 related to Service Broker?

A. Less support for Service Broker
B. Queues do not expose the message enqueued time
C. Messages can be sent to multiple target services (multicast)
D. All of the mentioned
Answer» D. All of the mentioned
Discussion
4.

(SSBS) is a new architecture which allows you to write ____________ message based application.

A. asynchronous
B. decoupled
C. distributed
D. all of the mentioned
Answer» E.
Discussion
5.

Service Broker also provides security by preventing __________ access from networks and by message encryption.

A. Authorized
B. Read
C. Unauthorized
D. All of the mentioned
Answer» D. All of the mentioned
Discussion
6.

Which of the following service broker component defines the infrastructure used for exchanging messages between instances ?

A. Conversation
B. Service definition
C. Security
D. All of the mentioned
Answer» B. Service definition
Discussion
7.

There are _________ components of the Service broker in SQL Server.

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

Service broker was added to SQL Server ___________

A. 2000
B. 2005
C. 2008
D. 2012
Answer» C. 2008
Discussion