Explain the advantages and disadvantages of using dynamic SQL compared with ODBC and JDBC.
What will be an ideal response?
1. Advantages: Dynamic SQL can use all the proprietary extensions to SQL provided by the special DBMS, while JDBC and ODBC can not;
2. Disadvantages: In ODBC, the SQL statements use a generic dialect. Likewise, in JDBC, a common core of SQL is guaranteed to be supported by all drivers. If the application is moved to a di?erent DBMS, only the the driver need be changed. (In JDBC, the application should be restricted to the common SQL core). In contrast, with dynamic SQL the actual SQL statements might have to be rewritten.
You might also like to view...
Which application-level gateway task provides the benefit to an internal network of shielding actual internal IP addresses from the prying eyes of unauthorized external clients?
A. Spoofing B. IP address mapping C. Load balancing D. URL filtering
Describe the ACPI G1 state and its four S states.
What will be an ideal response?
The ____________________ method releases resources and frees up memory connected to an Activity.
Fill in the blank(s) with the appropriate word(s).
There are five questions that you should answer before adding memory to a system. List three of those five.
What will be an ideal response?