This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Service Broker”.
1. Service broker was added to SQL Server ___________
a) 2000
b) 2005
c) 2008
d) 2012
View Answer
Explanation: Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances.
2. Point out the correct statement.
a) Loosely coupled applications are supported by the Service broker
b) Each Service Broker conversation is considered to be a dialog where only participants are involved
c) Service broker find applications when a single SQL server instance is used
d) None of the mentioned
View Answer
Explanation: Programs that exchange messages independently) are supported by the Service broker.
3. There are _________ components of the Service broker in SQL Server.
a) 2
b) 3
c) 4
d) 5
View Answer
Explanation: The three components of the Service broker are as follows: conversation components, service definition components and networking and security components.
4. 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
View Answer
Explanation: Networking and security components defines the infrastructure used for exchanging messages between instances.
5. Point out the wrong statement.
a) The developers can design applications from independent components known as “services”
b) The maintenance of the Service Broker is difficult
c) Maintenance of Service Broker is a part of the routine database
d) None of the mentioned
View Answer
Explanation: The maintenance of Service Broker is easy because it forms a part of the Database Engine.
6. 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
View Answer
Explanation: Service broker is essential component for security of database.
7. (SSBS) is a new architecture which allows you to write ____________ message based application.
a) asynchronous
b) decoupled
c) distributed
d) all of the mentioned
View Answer
Explanation: SQL Server Service Broker (SSBS), introduced with SQL Server 2005 allows you to write queuing/message based applications within the database itself.
8. 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
View Answer
Explanation: Queues have a new column, message_enqueue_time, that shows how long a message has been in the queue.
9. 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
View Answer
Explanation: sys.dm_broker_activated_tasks returns a row for each stored procedure activated by Service Broker.
10. Which of the utility is used for reporting the issue in Service Broker?
a) diagnose
b) ssiagnose
c) ssbdiagnose
d) none of the mentioned
View Answer
Explanation: The ssbdiagnose utility reports issues in Service Broker conversations or the configuration of Service Broker services.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]
- Check Information Technology Books
- Check SQL Server Books
- Practice Programming MCQs
- Apply for Programming Internship
