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 9711

Is JDBC a language or Application?

3 6453

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

2 4213

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,

2224

all Java qts are imp ?

eBay,

1 4776

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 9742

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

2 4728

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

1 3243

How we store procedure in oralce for callable statements in jdbc

2387

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 4954

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 25302

What will happen when ResultSet is not closed?

CTS,

1 7110

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

4 12644

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

HCL,

1 5588

what are the drawbacks of JDBC? explain briefly?

5 42209

Post New JDBC Questions

Un-Answered Questions { JDBC }

How does a file store compare with a jdbc store?

1272

What is data source in java?

1014

What are jdbc?

1015

Is java a database?

1015

Which type of driver provides jdbc access via one or more odbc drivers?

945

How many categories of jdbc drivers are there?

963

What does executeupdate return in java?

1094

What is isolation level? How to set it?

2311

Is jdbc connection secure?

1011

Can resultset be null in java?

984

What are the classes and methods used for sending sql statements to database?

1143

What is the reason why we need a jdbcrowset like the wrapper around resultset?

1024

Why should we close database connections in java?

1195

Why do we use jdbc in java?

1124

How do we load the drivers?

1066

For More Un-Answered { JDBC } Questions Click Here