Select chapter



basics (7.papers)
constructors (1.papers)
packages (1.papers)
inheritance (7.papers)
misc (3.papers)
exceptions (5.papers)
threads (4.papers)
overloading (1.papers)
jsp (3.papers)
servlets (9.papers)
jdbc (2.papers)
util (1.papers)
xml (2.papers)
IO stream (3.papers)
Hide

Sponsored Links


  

java jdbc interview questions and answers

1
Which class provides  transaction support methods?
  1. Statement
  2. CallableStatement
  3. Connection
  4. DriverManager
Show Answer
Share Facebook gmail Twitter
2
Which JDBC driver is the fastest?
  1. Type I
  2. Type II
  3. Type III
  4. Type IV
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
5
Full form of JDBC?
  1. Java Data Binding Connection
  2. Java Database Connectivity
  3. Java Developer Base Connectivity
  4. Java Database Creativity
Show Answer
Share Facebook gmail Twitter
6
Which of the following code sets ensure that all the results for a statement are processed?
  1. Statement stmt = con.createStatement();
    stmt.execute(sqlString){
     ResultSet rs = stmt.getReultSet();
     while(rs.next()){
     
    //display results
     }
  2. Statement stmt = con.createStatement();
    stmt.execute(sqlString){
    while(true){
     rs = stmt.getResultSet();
     // display results
     if(stmt.getMoreResults() == false)
    break;
    }
  3. Statement stmt = con.createStatement();
    stmt.execute(sqlString){
    while(true){
     rs = stmt.getResultSet();
     // display results
     if(stmt.getMoreResults() == false) &&
    (stmt.getUpdateCount() == -1))
    break;
    }
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
9
How does the following JDBC code function? Select valid options: ResultSet rs = stmt.executeQuery("Select NAME, CUSTOMER_ID from CUSTOMERS");
rs.moveToInsertRow();
rs.updateString(1,"John");
rs.updateInt(2,12345);
rs.insertRow();
  1. 1.Lists the Name and Customer_ID of Customer table
    2.Replaces first row of the table with the new updated data
  2. 1.Lists the Name and Customer_ID of Customer table
    2.Replaces last row of the table with the new updated data
  3. 1. Creates a blank row with ResultSet that has all fields but no data.
    2. Load new data  into the inserted row
    3. Append new row to the table
  4. 1. Moves to the last row of the table.
    2. Creates a row with new updated data and then insert the row into the table. 
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Read more papers :