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

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.
Discussion
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)
Discussion
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
Discussion
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>, ‚Äö√Ñ√∂‚àö√묨‚àÇ].
Discussion
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
Discussion
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.
Discussion