Suppose that, at compile time, the application programmer knows all of the details of the SQL statements to be executed, the DBMS to be used, and the database schema. Explain the advantages and disadvantages of using embedded SQL as compared with JDBC or ODBC as the basis for the implementation.
What will be an ideal response?
Embedded SQL is more e?cient than JDBC and ODBC because the syntax can be checked at compile time and parameter passing is more e?cient. Also there is less communication involved.
Computer Science & Information Technology
You might also like to view...
DoS attacks are rare against wired network servers.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
The ____________________ is a unique number representing the username.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology
Malware that is portable to all operating systems or platforms is considered web-based code
Indicate whether the statement is true or false.
Computer Science & Information Technology
Describe the disadvantages of passive display technology.
What will be an ideal response?
Computer Science & Information Technology