Question

_________ can be applied to the metadata or to an active session and the metadata.

(a) DROP EVENT SESSION

(b) ALTER EVENT SESSION,STATE=STOP

(c) ALTER EVENT SESSION,STATE=START

(d) All of the mentioned

This question was addressed to me in an interview for job.

My question is based upon Extended Events in section Monitoring and Auditing of SQL Server

Answer 1

The correct answer is (d) All of the mentioned

The explanation: Both ALTER EVENT SESSION and DROP EVENT SESSION can be applied to the metadata or to an active session and the metadata.