MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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. | |
| 2. |
SET_SHOWPLAN_TEXT_is_intended_to_return_readable_output_for__________utility.$ |
| A. | osql |
| B. | tsql |
| C. | plsql |
| D. | pgsql |
| Answer» B. tsql | |
| 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 | |
| 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. | |
| 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 | |
| 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 | |
| 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 | |
| 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 } | |