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