pradeepkmr18

 Profile Answers by pradeepkmr18 Questions by pradeepkmr18

• Jul 3rd, 2008

We have to select the driver based on reqirement .

arun kumar

• Dec 7th, 2005

Hi, there, the order in which the drivers can be used is 4213, :) bye

Answer Question  Select Best Answer

A) A result set that is TYPE_SCROLL_INSENSITIVE does not reflect changes made while it is still open and one that is TYPE_SCROLL_SENSITIVE does.B) Both types of result sets will make changes visible if they are closed and then reopened.C) You will get a scrollable ResultSet object if you specify one of these ResultSet constants.D) A result set that is TYPE_SCROLL_INSENSITIVE makes the result set read...

vk payne

• Feb 8th, 2013

A,B and D
All the three are correct

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

The wrong option and hence the correct answer is (d)

Answer Question  Select Best Answer

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

virender

• Dec 16th, 2017

1,3,4,2

nandhini

• Aug 8th, 2017

B) 1,3,4,2

Answer Question  Select Best Answer

A) A Type 1 driver is a JDBC-ODBC bridge driverB) This type of driver enables a client to connect to an ODBC database via Java calls and JDBCC) Both the database and middle tier need to be Java compliant.D) ODBC binary code must be installed on each client machine that uses this driver.Explanation: Neither the database nor the middle tier needs to be java compliant.

abhi

• Dec 15th, 2006

C is the ans

virendra maurya

• May 29th, 2006

C is the wrong one

Answer Question  Select Best Answer

sambasiva

• Dec 11th, 2006

 hi jaisankar In fact, it is the responsible of driver vendor to provide implemention class for connection interface. Collection of these type classes called as drivers. ...

Jaishankar

• Nov 10th, 2006

hi,  can you be clear about this answer.  is it that connection interface is being implemented by the vendor in the jar Files they provide.If so wht class it will be.Thanks in advanceRegardsJaishankar

Answer Question  Select Best Answer

Supriya Ahire

• Feb 2nd, 2007

Hello All, Types of Resultsets are 1)TYPE_FORWARD_ONLY 2) TYPE_SCROLL_INSENSITIVE 3)TYPE_SCROLL_SENSITIVE DEFAULT Type of resultset is TYPE_FORWARD_ONLY. Regards, Ms.Supriya Ahire

Supraja

• Dec 10th, 2006

TYPE_FORWARD_ONLY The result set is nonscrollable; its cursor moves forward only, from top to bottom. The view of the data in the result set depends on whether the DBMS materializes result...

Answer Question  Select Best Answer

which of the following methods eliminates the need to call wasNull() method to handle null database fields?a)getObject()b)getInt()c)getString()d)getFloat()e)getNull()

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

To my understanding, the question  isn't framed properly. The answers given by two fellows above are ways to go around this situation but none eliminates the need to call wasNull().Other views are appreciated !!!

kittupeddi

 Profile Answers by kittupeddi Questions by kittupeddi

• Apr 10th, 2008

Two Ways:1> Use the wasNull() method on the ResultSet.2> Use the getObject() method on the ResultSet and do the Comparision.

Answer Question  Select Best Answer

A user leaves an online shopping cart without checking out.Which of the following interfaces will notify to rollback the transaction?a)HttpSessionb)HttpSessionBindingListenerc)HttpServletd)SingleThreadModele)FtpSession

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

(b)HttpSessionBindingListener is the correct answervalueBound() and valueUnbound() are the methods that should be over-ridden to get this implemented.Thanks.Vinay

phanikhk

 Profile Answers by phanikhk Questions by phanikhk

• Apr 9th, 2008

Any class can implement HttpSessionBindingListener interface. This interface includes two methods, valueBound() and valueUnbound(), that are called whenever the object that implements the interfa...

Answer Question  Select Best Answer

What is the purpose of creating ODBC data source in establishing a connection between Java application & database?

sindhumsc

 Profile Answers by sindhumsc Questions by sindhumsc

• Aug 24th, 2010

ODBC stands for open database connectivity which helps us to connect then link from Java to database..so if we want to connect from Java to any database one way is to use ODBC which helps to connect Java to any database (like Oracle, MySQL..).

vana_mlk

 Profile Answers by vana_mlk Questions by vana_mlk

• Jul 2nd, 2010

Shine pattern has JConnection for connecting to any database.

Answer Question  Select Best Answer

A) ODBC can be directly used with Java because it uses a C interfaceB) ODBC makes uses of pointers which has been totally removed from JAVAC) ODBC is from Microsoft while JDBC is from java applicationsD) ODBC requires manual installation of the ODBC driver manager and driver on all client machines. While for JDBC driver are written in Java and JDBC code is automatically installable, secure and portable...

Suhas Lonarkar

• Jun 10th, 2006

Because ODBC being a c based interface cannot be directly used with java

palavarapu sravankumar

• Apr 19th, 2006

Iguess answer is A  because it uses a interfaces

Answer Question  Select Best Answer

A) Regular Statement (use createStatement method)B) Prepared statement (use prepareStatement method)C) Callable statement (use prepareCall).D) Interim statement (use jdbcCall).

maneesh.ce.2007

 Profile Answers by maneesh.ce.2007 Questions by maneesh.ce.2007

• Dec 29th, 2008

D is false

ramasomepalli

 Profile Answers by ramasomepalli Questions by ramasomepalli

• Dec 27th, 2008

D) Interim Statement

Answer Question  Select Best Answer

A) When a connection is created, it is in auto-commit mode.B) If the value is true each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed.C) once auto-commit mode is disabled, no SQL statements will be committed until you call the method commit explicitlyD) By default the JDBC call is in auto-commit mode.Explanation: by default the JDBC...

Harish

• Apr 10th, 2018

Answer is : D

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

The answer is (b) per my understanding

Answer Question  Select Best Answer

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