Explanation/Reference:
Explanation:
SET SHOWPLAN_ALL ON causes Microsoft SQL Server not to execute Transact-SQL statements.
Instead, SQL Server returns detailed information about how the statements are executed and provides
estimates of the resource requirements for the statements.
Incorrect Answers:
D: When STATISTICS PROFILE is ON, each executed query returns its regular result set, followed by an
additional result set that shows a profile of the query execution.
Displays the profile information for a statement. STATISTICS PROFILE works for ad hoc queries, views,
and stored procedures.
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-showplan-all-transact-sql