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