Interview Questions

AJAX Interview Questions Android Interview Questions Angular 2 Interview Questions AngularJs Interview Questions Apache Presto Interview Questions Apache Tapestry Interview Questions Arduino Interview Questions ASP.NET MVC Interview Questions Aurelia Interview Questions AWS Interview Questions Blockchain Interview Questions Bootstrap Interview Questions C Interview Questions C Programming Coding Interview Questions C# Interview Questions Cakephp Interview Questions Cassandra Interview Questions CherryPy Interview Questions Clojure Interview Questions Cobol Interview Questions CodeIgniter interview Questions CoffeeScript Interview Questions Cordova Interview Questions CouchDB interview questions CSS Buttons Interview Questions CSS Interview Questions D Programming Language Interview Questions Dart Programming Language Interview Questions Data structure & Algorithm Interview Questions DB2 Interview Questions DBMS Interview Questions Django Interview Questions Docker Interview Questions DOJO Interview Questions Drupal Interview Questions Electron Interview Questions Elixir Interview Questions Erlang Interview Questions ES6 Interview Questions and Answers Euphoria Interview Questions ExpressJS Interview Questions Ext Js Interview Questions Firebase Interview Questions Flask Interview Questions Flex Interview Questions Fortran Interview Questions Foundation Interview Questions Framework7 Interview Questions FuelPHP Framework Interview Questions Go Programming Language Interview Questions Google Maps Interview Questions Groovy interview Questions GWT Interview Questions Hadoop Interview Questions Haskell Interview Questions Highcharts Interview Questions HTML Interview Questions HTTP Interview Questions Ionic Interview Questions iOS Interview Questions IoT Interview Questions Java BeanUtils Interview Questions Java Collections Interview Questions Java Interview Questions Java JDBC Interview Questions Java Multithreading Interview Questions Java OOPS Interview Questions Java Programming Coding Interview Questions Java Swing Interview Questions JavaFX Interview Questions JavaScript Interview Questions JCL (Job Control Language) Interview Questions Joomla Interview Questions jQuery Interview Questions js Interview Questions JSF Interview Questions JSP Interview Questions KnockoutJS Interview Questions Koa Interview Questions Laravel Interview Questions Less Interview Questions LISP Interview Questions Magento Interview Questions MariaDB Interview Questions Material Design Lite Interview Questions Materialize CSS Framework Interview Questions MathML Interview Questions MATLAB Interview Questions Meteor Interview Questions MongoDB interview Questions Moo Tools Interview Questions MySQL Interview Questions NodeJS Interview Questions OpenStack Interview Questions Oracle DBA Interview Questions Pascal Interview Questions Perl interview questions Phalcon Framework Interview Questions PhantomJS Interview Questions PhoneGap Interview Questions Php Interview Questions PL/SQL Interview Questions PostgreSQL Interview Questions PouchDB Interview Questions Prototype Interview Questions Pure CSS Interview Questions Python Interview Questions R programming Language Interview Questions React Native Interview Questions ReactJS Interview Questions RequireJs Interview Questions RESTful Web Services Interview Questions RPA Interview Questions Ruby on Rails Interview Questions SAS Interview Questions SASS Interview Questions Scala Interview Questions Sencha Touch Interview Questions SEO Interview Questions Servlet Interview Questions SQL Interview Questions SQL Server Interview Questions SQLite Interview Questions Struts Interview Questions SVG Interview Questions Swift Interview Questions Symfony PHP Framework Interview Questions T-SQL(Transact-SQL) Interview Questions TurboGears Framework Interview Questions TypeScript Interview Questions UiPath Interview Questions VB Script Interview Questions VBA Interview Questions WCF Interview Questions Web icon Interview Questions Web Service Interview Questions Web2py Framework Interview Questions WebGL Interview Questions Website Development Interview Questions WordPress Interview Questions Xamarin Interview Questions XHTML Interview Questions XML Interview Questions XSL Interview Questions Yii PHP Framework Interview Questions Zend Framework Interview Questions Network Architect Interview Questions

Top 15 Java JDBC Interview Questions for 2022

1) What are the types of JDBC Drivers in Java?

JDBC Drivers are of four types are:
  • JDBC-ODBC bridge driver
  • Native-API driver
  • Network Protocol driver
  • Thin driver

2) What are the five steps to connect to the database in Java?

Five steps to connect to the database are :
  • Step1: Register the driver class
  • Step2: Creating connection
  • Step3: Creating statement
  • Step4: Executing queries
  • Step5: Closing connection

3) What are the commonly used methods of DriverManager class in Java?

Commonly used methods of DriverManager class are:
  • public static void registerDriver(Driver driver)
  • public static void deregisterDriver(Driver driver)
  • public static Connection getConnection(String url)
  • public static Connection getConnection(String url,String userName,String password)

4) What are the commonly used methods of Statement interface in Java?

The commonly used methods of Statement interface in java are:
  • public ResultSet executeQuery(String sql)
  • public int executeUpdate(String sql)
  • public boolean execute(String sql)
  • public int[] executeBatch()

5) What are the commonly used methods of ResultSet interface in Java?

The commonly used methods of ResultSet interface are:
  • public boolean next()
  • public boolean previous()
  • public boolean first()
  • public boolean last()
  • public boolean absolute(int row)
  • public boolean relative(int row)
  • public int getInt(int columnIndex)
  • public int getInt(String columnName)
  • public String getString(int columnIndex)
  • public String getString(String columnName)

6) What are the commonly used methods of PreparedStatement interface in Java?

The commonly used methods of PreparedStatement interface are:
  • public void setInt(int paramIndex, int value)
  • public void setString(int paramIndex, String value)
  • public void setFloat(int paramIndex, float value)
  • public void setDouble(int paramIndex, double value)
  • public int executeUpdate()
  • public ResultSet executeQuery()

7) What are the commonly used methods of ResultSetMetaData interface in Java?

The commonly used methods of ResultSetMetaData interface are:
  • public int getColumnCount()throws SQLException
  • public String getColumnName(int index)throws SQLException
  • public String getColumnTypeName(int index)throws SQLException
  • public String getTableName(int index)throws SQLException

8) What are the commonly used methods of DatabaseMetaData interface in Java?

The commonly used methods of DatabaseMetaData interface are:
  • public String getDriverName()throws SQLException
  • public String getDriverVersion()throws SQLException.
  • public String getUserName()throws SQLException
  • public String getDatabaseProductName()throws SQLException
  • public String getDatabaseProductVersion()throws SQLException
  • public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)throws SQLException

9) What are the types of ResultSet in Java?

There are three types of ResultSet in Java are:
  • TYPE_FORWARD_ONLY
  • TYPE_SCROLL_INSENSITIVE
  • TYPE_SCROLL_SENSITIVE

10) How can I connect Java Application with Oracle database in java?

Example:
import java.sql.*;    
class OracleConn  
{    
public static void main(String args[])  
{    
try  
{    
Class.forName("oracle.jdbc.driver.OracleDriver");    
Connection con=DriverManager.getConnection(    
"jdbc:oracle:thin:@localhost:1521:xe","system","oracle");  // Here system is username and oracle is password.  
Statement stmt=con.createStatement();    
ResultSet rs=stmt.executeQuery("select * from emp");    
while(rs.next())    
System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));    
con.close();    
}  
catch(Exception e)  
{   
System.out.println(e);  
}    
}    
}

11) How can I connect Java Application with mysql database in java?

Example:
import java.sql.*;    
class MysqlConn  
{    
public static void main(String args[])  
{    
try  
{    
Class.forName("com.mysql.jdbc.Driver");    
Connection con=DriverManager.getConnection(    
"jdbc:mysql://localhost:3306/atul","root","root");   // Here atul is database name and root is username and password.  
Statement stmt=con.createStatement();    
ResultSet rs=stmt.executeQuery("select * from emp");    
while(rs.next())    
System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));    
con.close();    
}  
catch(Exception e)  
{  
System.out.println(e);  
}    
}    
}

12) How many packages are available in JDBC API?

There are two types of packages are available in JDBC API:
  • Java.sql
  • Javax.sql

13) What are the commonly used implementation classes of RowSet interface in Java?

The commonly used implementation classes of RowSet interface are:
  • JdbcRowSet
  • CachedRowSet
  • WebRowSet
  • JoinRowSet
  • FilteredRowSet

14) What are the advantages of RowSet interface in Java?

Advantages of RowSet interface are:
  • easy to use
  • Flexible to use
  • Scrollable
  • Updatable bydefault

15) Result Sets index starts with 0 or 1?

ResultSet index starts with 1.