In SQL Server 2005, can you include a user-defin

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

(Continued from previous question...)

In SQL Server 2005, can you include a user-defined role as a member of another user-defined role?

Answer
Yes

Explanation
Yes you can.

(Continued on next question...)

Other Job Interview Questions

• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• Which of the queries is the best one for Janice to use to return the information she has been requested to provide?
• You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
• What does SEND do in SQL Server 2005?
• 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?
• In SQL Server 2005, what does instance aware mean for a service?
• A certificate is like which type of key in SQL Server 2005 encryption?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• How does a differential backup know which extents have changed so that it can be very quickly run?
• What are triggers? What are the different types of triggers in SQL Server 2000?
• More...