What is a dialog conversation in the SQL Server

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a dialog conversation in the SQL Server 2005 Service Broker.

Answer
A dialog conversation is a conversation between services.
Explanation
A dialog conversation is a conversation between services. A conversation includes messages being passed back and forth as part of a contract.

(Continued on next question...)

Other Job Interview Questions

• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• In a new default SQL Server 2005 installation, what is the status of the dedicated administrator connection?
• Can you call Notification Services APIs from unmanaged code?
• What is the result of the following query?
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• What does the ERROR_PROCEDURE() function return?
• You restart your SQL Server on a Sunday morning after some maintenance ...
• What is the default type of XML data if you do not specify an arguement?
• When you declare an XML variable in SQL Server 2005, what are the two types of typed XML data. What are they?
• How many rows are returned by these two select statements?
• More...