Which of the following statement is not true about embedded SQL?

Which of the following statement is not true about embedded SQL?

A. Embedded SQL expressions for database modification always returns a result.

B. An embedded SQL program must be processed by a special processor prior to compilation.

C. The exact syntax for embedded SQL request depends on the language in which SQL is embedded.

D. In embedded SQL, all query processing is performed by the database system.

Answer: Embedded SQL expressions for database modification always returns a result.

Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language.

An embedded SQL statement is parsed, rewritten and handled as an executable statement by a preprocessor before the compiler for the host language compiles the program. Some SQL databases use an external query engine that runs separately from any programming language to parse and execute SQL commands. In this case, embedding is not necessary; you can run a regular program that opens a database connection, sends over an SQL query and receives results to process further.

The alternative to embedded SQL is dynamic SQL, where strings containing SQL are sent to the database engine for parsing and execution. Embedded statements are compiled along with other program source code into machine code that can be executed directly on the server (or client) machine. Dynamic queries are handled by a separate engine that executes each statement at runtime as it receives them from client applications.