What does REVERT do in SQL Server 2005?

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

(Continued from previous question...)

What does REVERT do in SQL Server 2005?

Answer
Restores your previous execution context.

Explanation
If you have changed your execution context with EXECUTE AS, the REVERT statement will restore the last context priot to the EXECUTE AS.

(Continued on next question...)

Other Job Interview Questions

• What will occur with the following code in SQL Server 2005 if executed by Alice?
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• Which is larger in size in SQL Server 2005 if you are using symmetric keys?
• Can you use Full-text search to index this column?
• How secure are encrypted stored procedures, triggers and views?
• When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• What does the DUMP command do?
• What algorithm is used to encrypt the Database Master Key when it is created?
• More...