JDBC Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

JDBC Interview Questions

Questions Answers Views Company eMail

write a query to select name from one table which has id,name and salary from another table which has id, sal where the salary is the second maximum

Bosch, HireCraft, Infosys,

3 9577

Is JDBC a language or Application?

3 6360

how can we get the metaData (columnNames) from a table which has no Records..

2 4129

While in CallableStatament using in the oracle my procedure is return no.of columns so in java how can i retrivbe the data and i wnat to view all data which is reetrive from my procedure

ADP,

2143

all Java qts are imp ?

eBay,

1 4688

Hi friends, In JDBC 4 drivers are there among this which driver is best and why it is best.Which driver is most commonly used in web applications.

6 9566

I have written a program to connect to database using odbc.Can this Application run on any Platform????

2 4627

please tell me the name and url path for type-4 driver ?

1 3180

How we store procedure in oralce for callable statements in jdbc

2335

Give me some example for getting connection from connection pooling in JBoss Server. Is Connection Pool default in Server or we have to create it? Who can create Connection Pool in a Team. How it will be accessed by the developer code?

TCS,

1 4872

java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }

CTS,

6 25121

What will happen when ResultSet is not closed?

CTS,

1 7022

PreparedStatement is a pre compiled statement but where it's pre compiled ?

4 12487

can we create a own jdbc driver? how can we create?

HCL,

1 5524

what are the drawbacks of JDBC? explain briefly?

5 42005

Post New JDBC Questions

Un-Answered Questions { JDBC }

What is a datasource in java?

956

What are the advantages of using jdbc datasource?

987

What is the purpose of jdbc resultset interface?

991

What do you understand by jdbc driver and explain its types?

946

What is jdbc driver manager?

946

How can we set null value in jdbc preparedstatement?

966

When do we get java.sql.SQLException: No suitable driver found?

968

Which interface handles transaction management in jdbc?

1115

What is the full form of jdbc and what is its purpose?

1007

What packages are used by jdbc?

949

What is ODBC and JDBC? How do you connect the Database?

1042

Explain jdbc savepoint?

979

How do I stop nullpointerexception?

977

What is JDBC Driver interface?

1131

What are the advantages of collection pools?

1055

For More Un-Answered { JDBC } Questions Click Here