Q:
Difference between Embeded SQL and Dynamic SQL?
Answer
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.
View answer
Workspace
Report Error
Discuss
Aptitude and Reasoning
General Knowledge
Puzzles
Interviews
Technical
Certifications
Exams
Job
Roles
True or False
Exams