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 9451

Is JDBC a language or Application?

3 6189

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

2 4010

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,

2062

all Java qts are imp ?

eBay,

1 4573

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 9292

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

2 4512

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

1 3094

How we store procedure in oralce for callable statements in jdbc

2274

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 4795

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 24867

What will happen when ResultSet is not closed?

CTS,

1 6927

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

4 12313

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

HCL,

1 5428

what are the drawbacks of JDBC? explain briefly?

5 41722

Post New JDBC Questions

Un-Answered Questions { JDBC }

Which is better jpa or jdbc?

869

What is jdbc connection?

1047

How to check jdbc connection in linux?

963

How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?

966

How can I determine the isolation levels supported by my DBMS?

928

How many types of JDBC Drivers are present and what are they?

1063

Explain about the Try Block?

918

How can we move the cursor in a scrollable result set?

896

What is the full form of jdbc?

960

What is difference between java.util.Date and java.sql.Date?

1025

What are the methods which can verify the cursor particular position?

953

Why do we need jdbc?

988

How to invoke Oracle Stored Procedure with Database Objects as IN/OUT?

1013

What are the 4 types of jdbc drivers?

932

Why should we close database connections in java?

1093

For More Un-Answered { JDBC } Questions Click Here