MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 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. |
WHICH_OF_THE_FOLLOWING_IS_A_DISADVANTAGE_OF_DYNAMIC_SQL_??$ |
| A. | Stored procedure can not cache the execution plan for this dynamic query |
| B. | Stored procedure can cache the execution plan for this dynamic query |
| C. | Flexibility in your code that you can not get with standard SQL |
| D. | All of the mentioned |
| Answer» E. | |
| 2. |
THE_BASIC_SYNTAX_FOR_USING_EXECUTE_COMMAND:?$ |
| A. | SP_EXECUTE(@SQLStatement) |
| B. | EXEC_SQL(@SQLStatement) |
| C. | EXECUTE(@SQLStatement) |
| D. | All of the mentioned |
| Answer» B. EXEC_SQL(@SQLStatement) | |
| 3. |
The Dynamic SQL Queries in a variable are __________ until they are executed? |
| A. | Compiled |
| B. | Parsed |
| C. | Checked for errors |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 4. |
The calling syntax for sp_executesql is as follows: |
| A. | sp_execute <@stmt> [<@param1 data_type>,<@param2 data_type>, …]. |
| B. | sp_sql <@stmt> [<@param1 data_type>,<@param2 data_type>, …]. |
| C. | sp_executesql <@stmt> [<@param1 data_type>,<@param2 data_type>, …]. |
| D. | sp_executesql [<@param1 data_type>,<@param2 data_type>, …]. |
| Answer» D. sp_executesql [<@param1 data_type>,<@param2 data_type>, ‚Äö√Ñ√∂‚àö√묨‚àÇ]. | |
| 5. |
Dynamic SQL Statements in SQL Server can be easily built using : |
| A. | Cursor |
| B. | Stored procedure |
| C. | Function |
| D. | All of the mentioned |
| Answer» C. Function | |
| 6. |
Which of the following is way to build dynamic sql statements ? |
| A. | Writing a query with parameters |
| B. | Using sp_executesql |
| C. | Using EXEC |
| D. | All of the mentioned |
| Answer» E. | |