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!

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

HTML

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

Compiler Design

Unravel the process of translating source code into executable programs with our...

Human Computer Interaction

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

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...