Explanation:STATISTICS PROFILE works for ad hoc queries, views, and stored procedures. 4. To produce execution plan output by using most Showplan Transact-SQL SET options, users must have
A. SHOW SHOWPLAN
B. SHOW PLAN
C. SHOWPLAN
D. None of the mentioned
Answer:A
Explanation:STATISTICS PROFILE works for ad hoc queries, views, and stored procedures. 4. To produce execution plan output by using most Showplan Transact-SQL SET options, users must have
A. SHOW SHOWPLAN B. SHOW PLAN C. SHOWPLAN D. None of the mentioned
Explanation:The SHOWPLAN permission on the databases that contain objects referred to in the Transact-SQL statement, such as views, stored procedures, or user-defined functions. 5. Point out the wrong statement :