JDBC Interview Questions

1,2,3

D is the answer. These three methods are used to store the objects.

A,B and D
All the three are correct

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

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

B & C is correct

executeUpdate() is ment for Non-Select Statements,,and it returns Update Count as an int value.

executeQuery() is ment for Select Statements, and it returns ResultSet.

executeQuery() is used for Select statements.
executeUodate() is used for insert,update,delete statements..

The difference between these two statements are
1) SQL Query will be compiled every time it is executed. whereas Stored Procedures are compiled only once when they are executed for the first time
2) Stored Procedure is efficient & fast execution than SQL query

JDBC-ODBC Bridge is a type 1 JDBC driver which converts JDBC operations in to C language ODBC APIs and then ODBC calls are then passed to appropriate ODBC driver.

Type1: JDBC-ODBC Bridge driverThis is a "birdge" driver, Translates all JDBC calls into ODBC calls and sends them to ODBC driver and ODBC inturn will communicate with a database. The Java Na...

No it does not contain any full form. It is Java based data access technology and we use it as Java database connectivity for our convenience.

JAVA DATABASE CONNECTIVITY

u store the object of a class in database. but database is meant for storing the values in the table format. for that reason only sun introduced JNDI for storing the object. by using this concept u can store the object in registry software. with that u can provide the global visibility also

1. Please make sure the java object is serializable
2. Serialize the java object into a file
3. Store the content of the file to relational database as Blob

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

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.

Java Native Interface (JNI)

To update data in multiple table using single click ,we can go with triggers in database.we have different types of triggers like after insert,after update,after delete.Better using triggers.

By using Transactions.

Every JDBC Driver will be able to perform Transactions. But its not recommended.

If we want to use out own Transactions we will set

con.setAutoCommit(false); and after executing the transactions we will execute con.commit();

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.

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. 

As of now it is not possible.

Constructor does not have any return type .. the answer is ,we don't have ny rights to call constructor , we can't invoke the constructor but at the type of object creation constructor automatically g...

"c class hello { void hello(int x) { System.out.print("hi"); } } class main { public static void main(String[] s) { hello ab=new hello(); ...

The getX() method is used, where X is String or Int depending on the type used in the database.

getString() method is used to retrieve data from the resultset

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

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.

class.forname is used to load a class.
When we are making database connectivity then class.forname(................) must be the first statement.

three statements in jdbc1. statement : whic is used to execute select and non select queries.2. PreapreStatement : which is also used to execute select and non select queries but PrepareStatement whic...

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.

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