Which permission in SQL Server 2005 allows you t

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

(Continued from previous question...)

Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?

Answer: Impersonate

Explanation: The IMPERSONATE permission is required to change context to that of another login.

(Continued on next question...)

Other Job Interview Questions

• Can you give me an overview of some of the database objects available for use in SQL Server 2000?
• How secure are encrypted stored procedures, triggers and views?
• What does this return on SQL Server 2005? select NEWSEQUENTIALID()
• True or false, Report Builder supports using the LIKE function inside filters?
• What is the default type of XML data if you do not specify an arguement?
• What does this return? select (1324 & 1024)
• When you declare an XML variable in SQL Server 2005, what are the two types of typed XML data. What are they?
• What does the function ORIGINAL_LOGIN return in SQL Server 2005?
• What does SEND do in SQL Server 2005?
• What message types exist in SQL Server 2005 Service Broker?
• More...