SQL MCQ Set 1 1. Which of the following syntax is valid ? a) SET SHOWPLAN_XML { ON | OFF } b) SET SHOWPLAN { ON | OFF } c) SET SHOW_XML { ON | OFF } d) None of the mentioned AnswerAnswer: a [Reason:] SET SHOWPLAN_XML causes SQL Server not to execute Transact-SQL statements….