SELECT USER_NAME() -- Returns Andy

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

(Continued from previous question...)

SELECT USER_NAME() -- Returns Andy

What does this return?
SELECT USER_NAME() -- Returns Andy
EXECUTE AS Brian
GO
EXECUTE AS Steve
GO
REVERT
GO
SELECT USER_NAME()


Answer
Brian

Explanation
The execution context switches can be nested, so changing to Brian, then Steve, then issuing a Revert will return you to the context of Brian. This works in the same manner as a stack.

(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?
• In SQL Server 2005, what does instance aware mean for a service?
• What does @@options return?
• What's SQL Server
• What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• What is a primary key? What is a foreign key?
• Which of the following statements best describes the filter capabilities of Report Builder?
• More...