WHICH OF THE FOLLOWING IS AN EXECUTION CONTEXT

15. Which of the following is an Execution Context?

A. Execute sp_srvrolepermission

B. Execute sp_dbfixedrolepermission

C. Execute sp_addrole

D. Execute AS user_name

The correct answer is D. Execute AS user_name is an Execution Context

that can be used to execute an object such as a stored procedure under the

permission of a particular user_name. Answers A, B, and C are not

Execution Contexts.