Supraja

• Dec 2nd, 2005

This link may be quite usefulhttp://www.precisejava.com/javaperf/j2ee/JDBC.htm#JDBC102

justAnother

• Nov 15th, 2005

The following is some information I could find on web regarding JDBC drivers:- The following website (not sure about the information) maintains a list of drivers and their usehttp://www.sqlsummit.com/...

Answer Question  Select Best Answer

A) Java Native InterfaceExplanation: Any all-Java JDBC driver should work with J++

A) Class.forName

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.

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...

A) TrueB) FalseExplanation: There are also methods that let you move the cursor to a particular row and check the position of the cursor

rmaghi@yahoo.com

 Profile Answers by rmaghi@yahoo.com Questions by rmaghi@yahoo.com

• Dec 13th, 2005

True

Answer Question  Select Best Answer

A) TrueB) FalseExplanation: The JDBC 2.0 API is the latest update of the JDBC API. It contains many new features, including scrollable result sets and the new SQL:1999 (formerly SQL 3) data types.

rmaghi@yahoo.com

 Profile Answers by rmaghi@yahoo.com Questions by rmaghi@yahoo.com

• Dec 13th, 2005

A. True

Answer Question  Select Best Answer

A) Create a CallableStatement object.B) A CallableStatement object contains a call to a stored procedure.C) The execution call should be like CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");D) We need not make an instance of the Connection class before making a Callable statement.Explanation: The callable statement is prepared based on the connection object only check option c, where...

krudupa9

 Profile Answers by krudupa9 Questions by krudupa9

• Dec 30th, 2005

Answer is DWe have to make a connection object as we call the method prepareCall() of connection object.

Answer Question  Select Best Answer

Saritha

• Jan 19th, 2006

Type 4 driver is pure java JDBC driver. every database has its own driver classes which are usually distributed through jar files.There is not specific installation for these drivers. If you want...

Answer Question  Select Best Answer

A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_READ.Explanation: A Dirty read allows a row changed by one transaction to be read by another transaction before any change in the row has been committed.

Sunanda

• Jan 20th, 2006

B) TRANSACTION_READ_ COMMITTED

Answer Question  Select Best Answer

A) The JDK 1.1 and the Java 2 SDK, Standard Edition (formerly known as the JDK 1.2), contain both the JDBC API and the JDBC-ODBC Bridge.B) The Java 2 SDK, Standard Edition, contains the JDBC 2.0 core API, does not include the JDBC 2.0 Optional Package, which is part of the Java 2 SDK, Enterprise Edition, or which you can download separately.C) The JDK 1.1 and the Java 2 SDK, Standard Edition (formerly...

Mchandra

 Profile Answers by Mchandra Questions by Mchandra

• Jan 22nd, 2006

A is correct

Answer Question  Select Best Answer

Create an instance of a JDBC driver or load JDBC drivers through jdbc.driversRegister a driverSpecify a databaseOpen a database connectionSubmit a queryReceive results

srilatha

• Jan 22nd, 2006

import java.sql.*;class Type1 { public static void main(String[] args)throws Exception {  Connection c=null;  try  {    Driver d=new Driver("sun....

Jayachandran

• Jan 3rd, 2006

Please Can any post the sample code for this set of operations. How do we register ?. Through DirverManager or what else ?

Answer Question  Select Best Answer

The JDBC Driver interface provides vendor-specific implementations of the abstract classes provided by the JDBC API. Each vendors driver must provide implementations of the java.sql.Connection,Statement,PreparedStatement, CallableStatement, ResultSet and Driver.

pavan

• Feb 3rd, 2006

As has been mentioned above, the implementations are provided by the database vendors like for example, the classes12.jar of oracle which has the implementations.

Ravi

• Aug 23rd, 2005

In jdbc connecion is a interface , we are using the methods in that interface but we didnt provide any implementation where is the implementation? 

Answer Question  Select Best Answer

Naim Kazi

• Feb 14th, 2006

But guys prepared statement has one disadvantage that it holds the data in the database. So when you execute a prepared statement for the first time, it will save the data in the database so that for ...

Anurjay Pradhan

• Nov 22nd, 2005

Prepared Statement is Pre-compiled class , but Statement is not.So in PreparedStatement the execution will be faster.

Answer Question  Select Best Answer

A) 1B) 2C) 1, 2D) Neither of the above

ravikumarzee@gmail.com

 Profile Answers by ravikumarzee@gmail.com Questions by ravikumarzee@gmail.com

• Feb 16th, 2006

Both 1 and 2 are correct. A static block is  written in every Driver class to register the driver, which gets executed when the class is loaded.

kiranreddy_zwx

 Profile Answers by kiranreddy_zwx Questions by kiranreddy_zwx

• Jan 9th, 2006

B

Answer Question  Select Best Answer

A) No suitable driver

Raghunath

• Feb 23rd, 2006

When ever an attempt is made to load the invalid driver information compiler time exception arises asValid Driver Information can not be found

Answer Question  Select Best Answer

damu

• Apr 8th, 2006

I ihave learnt the answer in very easy way for the  question what is the need of BatchUpdates? i have lot of doubts regarding j2ee and xml will u pls slove my problems

GVRaju

• Mar 29th, 2006

It will reduce the no. of calls making from front end to backend.usually when we want to insert 3 records to db from frontend, instead of making 3 request calls to db, add all the three request to batch and make only one request, so that all the 3 records will be inserted.

Answer Question  Select Best Answer

Bhaumik Patel

• Apr 27th, 2006

To do connection pooling in webLogic 9.01. Start the weblogic server.2. Open the weblogic console (url: http://localhost:7001/console) and log on using your username and password.3. In the left side t...

Answer Question  Select Best Answer

Gandharv

• May 1st, 2006

ResultSetMetaData interface is used to find out the types and properties of the column in the ResultSet whereas DatabaseMetaData interface provides comprehensive information about the database as a whole.

ashok

• Mar 21st, 2006

If u want to make ur application as idenpendent of the database tables,thenu can dynamically retreive the information about the database using the DatabaseMetaData and can retrieve information about the tables in the database using the ResultSetMetaData 

Answer Question  Select Best Answer