WHICH_OF_THE_FOLLOWING_IS_A_DISADVANTAGE_OF_DYNAMIC_SQL_??$

Question

TuteeHUB · Accepted Answer

NA

TuteeHUB · Answer

Stored procedure can not cache the execution plan for this dynamic query

TuteeHUB · Answer

Stored procedure can cache the execution plan for this dynamic query

TuteeHUB · Answer

Flexibility in your code that you can not get with standard SQL

TuteeHUB · Answer

All of the mentioned

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