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

JDBC Interview Questions

Questions Answers Views Company eMail

r u used any design patterns in your project?

Wipro,

3 7947

What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question is when that precompiled statement will be execute or comiple?................

TCS,

6 12568

After creating conntinpool in weblogic how to write the code in programe where i can use that pool object in the programe connecting to the database and how to debug programe withou eclipse

Wipro,

2 5726

Hi to all.. well i want to make a standalone application which can use the concept of connection pooling, constraint is that i have not to use any application server like weblogic etc. Please help me out. Thaks in advance.

Huawei,

3 7003

How to find the column count in resultset?

Wipro,

1 5484

How to find total column from a resultset?

TSYS,

6 13570

preparedstatement p= new preparedstatement is it possible ?

Fidelity, IBM, Infrasys,

10 19548

callable is interface or class ?

Fidelity,

9 17895

which scenarios we go for jdbc,and which scenario we go for connection polling and wat r advantages and disadvantages using connection pooling.

TCS,

2 6652

what is rowset?

Marlabs,

3 9582

how to retrieve sql exceptions

Bosch,

2 7388

Explain how data flows from view to db and reverse

Bosch,

2090

How to handle when the database crashes while reading the data from the database?

IBM,

2 6949

dear friends I have made connection with SQLSERVER where the following code is compiling properly but giving error at the runtime . I think error in this line where i am sending the value through string Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); import java.sql.*; //import mssqlserver.*; public class TestSQLCON { public TestSQLCON() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); System.out.println(); System.out.println("Successfully connected one"); System.out.println(); Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("\nDriver Information"); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("Database Name: " + meta.getDatabaseProductName()); System.out.println("Database Version: "+ meta.getDatabaseProductVersion()); } } public static void main (String args[]) throws Exception { TestSQLCON test = new TestSQLCON(); } } so please help me

2 5449

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset fetch all 1000 records at a time?

HSBC,

8 21599

Post New JDBC Questions

Un-Answered Questions { JDBC }

What is data source in java?

1014

What is the return type of class.forname() method?

1002

any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.

2355

What is the difference between setmaxrows(int) and setfetchsize(int)?

1118

What is jdbc and jdbc drivers?

1061

What is a jdbc driver and how many jdbc drivers are available?

1122

How you restrict a user to cut and paste from the html page using java programing?

944

What are the common jdbc exceptions?

998

What is jdbc driver in java?

974

What is the use of statement in jdbc?

986

What is the difference between client and server database cursors?

1254

What are the different types of JDBC drivers?

1102

What is jdbc stand for?

990

Explain the locking system in jdbc & its types?

1058

How does a custom RowSetReader get called from a CachedRowSet?

1141

For More Un-Answered { JDBC } Questions Click Here