Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

THE_WAY_THAT_A_STATEMENT_CAN_BE_PHYSICALLY_EXECUTED_IS_CALLED_:?$

A. query plan
B. execution plan
C. query execution plan
D. all of the mentioned
Answer» E.
Discussion
2.

SET_SHOWPLAN_TEXT_is_intended_to_return_readable_output_for__________utility.$

A. osql
B. tsql
C. plsql
D. pgsql
Answer» B. tsql
Discussion
3.

__________ returns detailed information about how the statements are executed?

A. SET STATISTICS XML
B. SET SHOWPLAN_TEXT
C. SET STATISTICS PROFILE
D. All of the mentioned
Answer» C. SET STATISTICS PROFILE
Discussion
4.

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» E.
Discussion
5.

The document containing the XML schema for the XML output by SET STATISTICS XML is located at :

A. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml. xml
B. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml. xsl
C. \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml. xsd
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
6.

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» D. None of the mentioned
Discussion
7.

___________ displays the profile information for a statement.

A. SET STATISTICS
B. SET STATS PROFILE
C. SET STATISTICS PROFILE
D. All of the mentioned
Answer» D. All of the mentioned
Discussion
8.

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
Answer» B. SET SHOWPLAN { ON | OFF }
Discussion