Explanation: SET STATISTICS XML produces XML output in the form of schema 7. 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
Answer:A
Explanation: SET STATISTICS XML produces XML output in the form of schema 7. 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
Explanation: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. 8. __________ returns detailed information about how the statements are executed.