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 7826

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 12370

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 5631

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 6883

How to find the column count in resultset?

Wipro,

1 5400

How to find total column from a resultset?

TSYS,

6 13392

preparedstatement p= new preparedstatement is it possible ?

Fidelity, IBM, Infrasys,

10 19227

callable is interface or class ?

Fidelity,

9 17640

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 6530

what is rowset?

Marlabs,

3 9456

how to retrieve sql exceptions

Bosch,

2 7266

Explain how data flows from view to db and reverse

Bosch,

2050

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

IBM,

2 6830

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 5357

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 21343

Post New JDBC Questions

Un-Answered Questions { JDBC }

Does jdbc use ssl?

933

Give an example of code used for setting up connection with a driver.

969

What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?

984

How can we store the file in the oracle database?

936

Explain the process of creating tables using NetBeans IDE?

976

What are the different classes through which JDBC represents statements?

923

What is metadata in programming?

1003

How many jdbc driver types are there?

923

What are the different types of locking in JDBC?

1011

How to move the cursor in scrollable resultset ?

1036

How can I get or redirect the log used by DriverManager and JDBC drivers?

935

What is a jdbctemplate?

935

What are the new features added to JDBC 4.0?

958

Is jdbc a web technology?

894

How do I check in my code whether a maximum limit of database connections have been reached?

992

For More Un-Answered { JDBC } Questions Click Here