How many users can be added to an application ro

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

(Continued from previous question...)

How many users can be added to an application role in SQL Server 2005?

Answer
None
Explanation
This is a trick questions. No users are added to application roles. Application roles are invoked by a user.

(Continued on next question...)

Other Job Interview Questions

• What does VARP() do in SQL Server 2005?
• What is the default type of XML data if you do not specify an arguement?
• A certificate is which type of security mechanism?
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• How many plans must you setup?
• How can you determine which Service Broker ports are being used on your server?
• What does the DUMP command do?
• You have a large table that you wish to partition to improve performance...
• What does the function ORIGINAL_LOGIN return in SQL Server 2005?
• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• More...