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.
A. SET STATISTICS XM
B. SET SHOWPLAN_TEXT
C. SET STATISTICS PROFILE
D. All of the mentioned
Answer:A
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.
A. SET STATISTICS XM B. SET SHOWPLAN_TEXT C. SET STATISTICS PROFILE D. All of the mentioned
Explanation:SET SHOWPLAN_TEXT causes Microsoft SQL Server not to execute Transact-SQL statements. 9. The way that a statement can be physically executed is called :