-
SQL query using JDBC
When you execute a SQL query using JDBC, do you get a complete recordset or the partial recordset?
-
-
-
JDBC-ODBC Bridge does not work with Microsoft J++, because it does not support ___________________
A) Java Native InterfaceExplanation: Any all-Java JDBC driver should work with J++
-
-
What is the precision of java.math.BigDecimal limited _____ digits in the JDK 1.0.2 add-on version of the JDBC API.
A) 18B) 24C) 32D) 64Explanation: because In JDK 1.1, java.math.BigInteger is implemented in C. It supports a precision of thousands of digits. The same is true for BigDecigmal.
-
Which of the following statements is false regarding the error returned by the driver manager return 'Data source name not found and no default driver specified Vendor: 0'.
A) This type of error occurs during an attempt to connect to a database with the bridge.B) The error is coming from the ODBC driver manager.C) The problem is due to the native libraries not present.D) The error is due to the fact that an ODBC DSN (data source name) needs to be configured on the client machineExplanation: the problem is because of the point d mentioned and not due to native DLL’s not...
-
How to Retrieve Warnings?
SQLWarning objects are a subclass of SQLException that deal with database access warnings. Warnings do not stop the execution of an application, as exceptions do; they simply alert the user that something did not happen as planned. A warning can be reported on a Connection object, a Statement object (including PreparedStatement and CallableStatement objects), or a ResultSet object. Each of these classes...
Ans