The Service Broker operates on messages in which

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

(Continued from previous question...)

The Service Broker operates on messages in which fashion?

Answer
Like a queue, first in, first out.

Explanation
Messages transferred in Service Broker work in a queue fashion with the first message being sent being the first processed.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• You have noticed in both your SQL Server 2000 and 2005 instances that when a database grows in SQL Server, there is a delay in the database response. Why is that?
• What method would you call to create this key?
• In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?
• How many credentials can one login be mapped to?
• What level of permissions does a user need to create an assembly with UNSAFE permissions?
• Assuming the column name is correct, which of the following is a valid cast operation in SSIS _expression language?
• What is an example of hardware partitioning?
• Which of the following datatypes can be represented in a SQL_VARIANT datatype?
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• More...