Question

Which of the following is valid syntax for SET STATISTICS XML?

(a) SET STATISTICS XML { OFF }

(b) SET STATISTICS XML { ON | OFF }

(c) SET STATISTICS XML { ON }

(d) All of the mentioned

I had been asked this question in an interview for internship.

I'm obligated to ask this question of Query Execution Plan in section Performance Tuning and Optimization of SQL Server

Answer 1

The correct answer is (d) All of the mentioned

The explanation is: SET STATISTICS XML causes Microsoft SQL Server to execute Transact-SQL statements and generate detailed information about how the statements were executed in the form of a well-defined XML document.