When revoking one security role from a user, doe

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

(Continued from previous question...)

When revoking one security role from a user, does it affect other security roles granted to same user?

No. Other security roles will remain granted to the user.

(Continued on next question...)

Other Job Interview Questions

• What is the default login account used by the installation process, when you are doing an unattended installation of MS SQL Server?
• What is the main purpose of assigning a user with the "processadmin" role?
• What is the default TCP/IP port # used by MS SQL Server to receive connection requests?
• What should you do to prepare for MS SQL Server upgrade?
• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• What is a Named Pipe in MS SQL Server?
• What is a Torn Page in MS SQL Server?
• What does Constraint refer to in MS SQL Server?
• 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...