A) A Type 2 driver converts JDBC calls into calls for a specific database.B) This driver is referred to as a "native-API, partly Java driver."C) As with the Type 1 driver, some binary code may be required on the client machine, which means this type of driver is not suitable for downloading over a network to a client.D) All of the above

francis

• Jan 13th, 2015

B

Supriya

• Dec 2nd, 2012

B) This driver is referred to as a "native-API, partly Java driver."

Answer Question  Select Best Answer

A) 1,2B) 2,3C) 1,3D) 1,2,3

Jerry Sam

• Jul 10th, 2015

D

meenakshi

• Apr 1st, 2013

1,2,3

Answer Question  Select Best Answer

siva kumar reddy

• Aug 7th, 2006

hi ,Class.forName("srting");when ever execute the above statement first chesks that class is loaded before or not .if not loaded it loads the class.Class.forName("oracle.jdbc.driver.OracleDriver");In this case driver manager loads the all drivers in the class.cheerssivaa

Jayant Dhargawe

• Jun 6th, 2006

Hi,Class is also class in java.lang package, it has a method getName(String arg) which take Driver Class u have supply libery in classpath lib directory. Its search given argrument and loading particular class into JVM. and use further process for getting connection from database.

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

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

Per my understanding and knowledge over the years, its the Native [java specific] protocol that is used in type4 drivers !!!Thanks,Vinay

Spoorthi

• Sep 13th, 2006

   jdbc:oracle:thin:@localhost:1521: our GlobalDatabasename

Answer Question  Select Best Answer

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

Yes it possible.... Please see public static Enumeration getDrivers() method in java.sql.DriverManager.DriverManager class which gives the complete list of Drivers available for use as an Enumeration.Thanks,Vinay

Supriya Ahire

• Feb 2nd, 2007

Hello, Yes , U can use two Class.forName() as Drivermanager keeps array internally to store the Drivernames so whichever come first will we loaded & used.Regards, Ms.Supriya Ahire

Answer Question  Select Best Answer

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

Database transactions => A group of SQL queries which should either all be executed or none should be executed will comprise of a tracnsaction.Maintain transactions using JDBC => We can do ...

trcdutt

 Profile Answers by trcdutt Questions by trcdutt

• Feb 15th, 2008

Here is a skeleton of code for implementing a transaction.import java.sql.Connection;public class Test {public void AllTransactionStatements() {    Connection con = getCon();  &nbs...

Answer Question  Select Best Answer

madhu

• Sep 5th, 2011

Always you should close connection. In some cases exception is thrown. When more processes get active in the same.

anand chaubey

• Aug 7th, 2011

If you don't close the connection,your application will eat up all your connection and your application will run out of connection and server will give error as no active connection and your application won't work.

Answer Question  Select Best Answer

When would you use a JDBC-ODBC Bridge?

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 7th, 2010

We use JDBC-ODBC bridge only when pure JDBC drivers are not available [say for connecting to a database] otherwise pure Java drivers are a good optoion.The use of JDBC-ODBC drivers isn't recommended v...

hsavinash2001

 Profile Answers by hsavinash2001 Questions by hsavinash2001

• May 26th, 2010

It is not recommended to use because of the dependency on native language (This is implemented in C++)

Answer Question  Select Best Answer

One implementation interface for database manufacturers, the other implementation interface for application and applet writers.

sujatham

 Profile Answers by sujatham Questions by sujatham

• Feb 7th, 2008

JDBC has four major components:1.The JDBC API2.The JDBC Driver Manager3.The JDBC Test Suite4.The JDBC-ODBC Bridge      The first two components of JDBC,the JDBC API and the JD...

Vasavi

• Sep 18th, 2007

The two major components of JDBC are 1. JDBC API: is a programming interface for database application developers, and2. JDBC Driver API: is a lower-level programming interface for developers of specific drivers.

Answer Question  Select Best Answer

A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_READ.Explanation: A non-repeatable read is where one transaction reads a row, a second transaction alters or deletes the row, and the first transaction re-reads the row,getting different values the second time.

Teja Divyakolu

• Oct 23rd, 2019

TRANSACTION REPETABLE READ

lai

• Dec 28th, 2016

C) TRANSACTION_SERIALIZABLE

Answer Question  Select Best Answer

prakash reddy

 Profile Answers by prakash reddy Questions by prakash reddy

• Apr 21st, 2008

Major differences the number layers present between the java application and database

asmita das

• Sep 7th, 2006

thick driver - type 1 and type 2 JDBC drivers are called thick drivers. The reason for it is - it provides JDBC access via ODBC drivers. ODBC binary code, and in many cases, database client code, must...

Answer Question  Select Best Answer

Sekhar

• Mar 15th, 2012

ResultSet rs; where rs is treat like a cursor to a database.if the connection is alive then only we can retrieve the information through resultset object.

RowSet rs;We can retrieve data through rowset object with out depending upon the connection is alive or not.

sudhakar

• Oct 15th, 2005

If the connection is alive, then only the values remain in a ResultSet, where as in RowSet,once we get the results connection need not be alive. 

Answer Question  Select Best Answer

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

To be straightforward, we can only compare two things when they are in the same scope/domain. This question says to differentiate b/w SPs and prepared statements isn't valid.Stored Procs are persi...

subhankar1982

 Profile Answers by subhankar1982 Questions by subhankar1982

• Feb 21st, 2009

Generally procedure and functions are written in PL/SQL code and it will reside in databases. When we develop some application in Java using JDBC to deal with specific databases for specific purpose...

Answer Question  Select Best Answer

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

class.forName(" Any Class Name Here") is a static method in Class class which returns the Class object associated with the class or interface with the given string name.....So when I say cl...

subhankar1982

 Profile Answers by subhankar1982 Questions by subhankar1982

• Feb 21st, 2009

Every JDBC driver vendor providing a static block for Driver classprovided by vendor. Which taking care of creating driver class object and registaring driver class , so instead of writing code Ex:- D...

Answer Question  Select Best Answer

pradeepkmr18

 Profile Answers by pradeepkmr18 Questions by pradeepkmr18

• Jul 3rd, 2008

Stored procedure contains set of sQL Statements thar are executed in the database by the sql stament processor.code:DECLARE NUM1 NUMBER:=10; NUM2 NUMBER:=20;BEGIN    DBMS_OUTPUT.PUT_LINE('sum:'||To_Char(NUM1+NUM2,'999.99'));END;

Hameed

• Oct 12th, 2005

Stored Procedure is an object design with business logic and stored in the database .Since it stays in the database ,the execution of the business logic is more faster...

Answer Question  Select Best Answer

This special type of statement is derived from the more general class, Statement. If you want to execute a Statement object many times, it will normally reduce execution time to use a PreparedStatement object instead. The advantage to this is that in most cases, this SQL statement will be sent to the DBMS right away, where it will be compiled. As a result, the PreparedStatement object contains not...

kalyan789

 Profile Answers by kalyan789 Questions by kalyan789

• Apr 23rd, 2009

Following above answer, we can set input values by specifying column index (index starts from 1) and value using corresponding Java set methods like setInt/String/Float etc.

sampra

 Profile Answers by sampra Questions by sampra

• Feb 11th, 2008

If we have to use palce holder mechnaism and pass compiled query in the sql engine the we use prepares stament.For one prepared stmt we can use only one query

Answer Question  Select Best Answer

A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_READ.Explanation: A phantom read is where one transaction reads all rows that satisfy a WHERE condition, a second transaction inserts a row that satisfies that WHERE condition, and the first transaction re-reads for the same condition, retrieving the additional 'phantom' row in the second...

sanky

• Jun 3rd, 2014

Charankk, please read question carefully. We need ans for which allows phantom read. We dont need ans for which does not allows. Ans is A,B,D

pradeepkmr18

 Profile Answers by pradeepkmr18 Questions by pradeepkmr18

• Jul 3rd, 2008

These will allow phanthom readRead_uncommitedRead_commitedRepeatable_read

Answer Question  Select Best Answer

Chandan

• Jun 20th, 2012

Connection pooling is a technique using which we can get the precreated connection object from the connection pool.After using that connection object, the connection object is released to the pool fo...

Suresh Yerra

 Profile Answers by Suresh Yerra Questions by Suresh Yerra

• Dec 11th, 2011

Usually Acquiring the connection is time consumption task. In order to avoid that situations, we are reusing already created connection objects. This requirement doesnot support DriverManager interface, we have interface DataSource in javax.sql package.

Answer Question  Select Best Answer

Answered by Jey Ramasamy on 2005-05-10 05:50:07: Class.forName() is used to load the Driver class which is used to connect the application with Database. Here Driver class is a Java class provided by Database vendor.

sankalpshah06

 Profile Answers by sankalpshah06 Questions by sankalpshah06

• Jun 21st, 2011

It is used to create an instance of a driver and register it with the DriverManager. When you have loaded a driver, it is available for making a connection with a Database.

ashwin1483

 Profile Answers by ashwin1483 Questions by ashwin1483

• May 15th, 2008

Class.forName is used to create an instance of the driver and register with the DriverManager.

Answer Question  Select Best Answer