Join Examsbook
514 0

Q: Difference between Embeded SQL and Dynamic SQL?

  • Show AnswerHide Answer
  • Workspace

Answer :
Explanation :

Static (embedded) SQL: 1.In static SQL how database will be accessed is predetermined in the embedded SQL statement. 2.It is more swift and efficient. 3.SQL statements are compiled at compile time. 4.Parsing, validation, optimization, and generation of application plan are done at compile time. 5.It is generally used for situations where data is distributed uniformly. 6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used. 7. It is less flexible    Dynamic (interactive) SQL: 1.In dynamic SQL, how database will be accessed is determined at run time. 2.It is less swift and efficient. 3.SQL statements are compiled at run time. 4.Parsing, validation, optimization, and generation of application plan are done at run time. 5.It is generally used for situations where data is distributed non-uniformly. 6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used. 7.It is more flexible.

Are you sure

  Report Error

Please Enter Message
Error Reported Successfully
google play

The Most Comprehensive Exam Preparation Platform

Get the Examsbook Prep App Today