Question

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

Posted under SQL Server

Answer: (b).sys.dm_broker_activated_tasks

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of the following is a Service Broker Related Dynamic Management View?

Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the utility is used for reporting the issue in Service Broker?

View solution

Q. ___________ is a set of technologies for copying and distributing data and database objects from one database to another.

View solution

Q. Point out the correct statement.

View solution

Q. How many types of replication is provided by SQL Server?

View solution

Q. Replication in SQL Server is used to overcome ________________

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following stored procedure provide replication support for AlwaysOn?

View solution

Q. How many types of replication components are present in SQL Server?

View solution

Q. Which of the following makes data available for replication?

View solution

Q. Two types of subscriptions present for replication is _____________

View solution

Q. SSMS provides different options to develop your SSIS package starting with ___________ wizard.

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following is the best practice related to SSIS?

View solution

Q. If SSIS is not able to drive close to 100% CPU load, this may be indicative of ____________

View solution

Q. Point out the wrong statement.

View solution

Q. The key counters for Integration Services and SQL Server are _______________

View solution

Q. _________ represents to total memory pressure on the system in SSIS.

View solution

Q. The following Network perfom counters can help you tune your topology?

View solution

Q. What do you understand by design limitation in SSIS package?

View solution

Q. ___________ represents how many network transfers per second are occurring.

View solution

View All MCQs on SQL Server

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...