Question

Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?

(a) Embedded SQL

(b) Dynamic SQL

(c) SQL declarations

(d) SQL data analysis

This question was addressed to me in quiz.

I'd like to ask this question from Access SQL From a Programming Language topic in division SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Correct option is (b) Dynamic SQL

Easiest explanation - Embedded SQL, the SQL statements are identified at compile time using a preprocessor. The preprocessor submits the SQL statements to the database system for precompilation and optimization; then it replaces the SQL statements in the application program with appropriate code and function calls before invoking the programming-language compiler.