Since the precompiler for embedded SQL translates SQL statements into procedure calls, explain the di?erence between embedded SQL and call-level interfaces, such as ODBC and JDBC, where SQL statements are speci?ed as the arguments of procedure calls.

What will be an ideal response?

With embedded SQL, the actual SQL statements to be executed are known at compile time while with the call-level interfaces, the SQL statement might not be known at compile time. They are just string variables that can be computed at run time and passed as arguments to host language procedures provided by the CLI. Thus in embedded SQL, the syntax of the SQL statements can be checked at compile time, and host language variables can be used as parameters of the SQL statements.

Computer Science & Information Technology

You might also like to view...

________ models software in terms similar to those that people use to describe real-world objects.

a. Object-oriented programming b. Object-oriented design c. Procedural programming d. None of the above

Computer Science & Information Technology

Draft view is best for entering and editing text because several of the page elements are hidden so that you can focus on writing and editing.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology