What is the different between concurrent connect

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

(Continued from previous question...)

What is the different between concurrent connections and concurrent user logins?

The concurrent connections refers to the total number of connections from all logged in users at a given moment.
The concurrent user logins refers to the total number of users logged in at a given moment.
A single logged in user can establish multiple connections at the same time.

(Continued on next question...)

Other Job Interview Questions

• What is default sorting order when you use "ORDER BY" clause in a query statement?
• During a BULK INSERT operation, are triggers and contraints enforced by default?
• What does RDBMS stand for?
• When revoking one security role from a user, does it affect other security roles granted to same user?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• What is the main limitation of the MS SQL Server Developer Edition?
• What does Field refers to in MS SQL Server?
• What does RDBMS stand for?
• When revoking one security role from a user, does it affect other security roles granted to same user?
• What is the size a Page in MS SQL Server?
• More...