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 7700

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 12114

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 5513

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 6723

How to find the column count in resultset?

Wipro,

1 5287

How to find total column from a resultset?

TSYS,

6 13135

preparedstatement p= new preparedstatement is it possible ?

Fidelity, IBM, Infrasys,

10 18831

callable is interface or class ?

Fidelity,

9 17338

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 6416

what is rowset?

Marlabs,

3 9304

how to retrieve sql exceptions

Bosch,

2 7129

Explain how data flows from view to db and reverse

Bosch,

1991

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

IBM,

2 6700

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 5243

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 21014

Post New JDBC Questions

Un-Answered Questions { JDBC }

Is jdbc database independent?

910

What are the different types of JDBC drivers?

1011

What is an advantage of using the jdbc connection pool?

826

What is odbc jdbc?

955

What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.

839

What are jdbc?

905

What is jdbc odbc?

940

Give an example for execution of sql statement.

963

What is a rollback in jdbc?

883

What is a connection string used for?

914

Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?

878

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

3094

What is ojdbc14 jar?

854

If you are truncated using JDBC, how can you that how much data is truncated?

1005

Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?

1133

For More Un-Answered { JDBC } Questions Click Here