{"id":15236,"date":"2022-09-09T12:30:43","date_gmt":"2022-09-09T07:00:43","guid":{"rendered":"https:\/\/btechgeeks.com\/?p=15236"},"modified":"2022-09-09T12:51:16","modified_gmt":"2022-09-09T07:21:16","slug":"java-database-connectivity-jdbc-interview-questions-in-java","status":"publish","type":"post","link":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/","title":{"rendered":"jdbc interview questions and answers for experienced &#8211; Java Database Connectivity (JDBC) Interview Questions in Java"},"content":{"rendered":"<p><strong>jdbc interview questions and answers for experienced: <\/strong>List of topic-wise frequently asked <a href=\"https:\/\/btechgeeks.com\/java-interview-questions\/\">java interview questions<\/a> with the best possible answers for job interviews.<\/p>\n<h2>Java Database Connectivity (JDBC) Interview Questions in Java<\/h2>\n<p>Question 1.<br \/>\nWhat is JDBC?<br \/>\nAnswer:<br \/>\nJDBC is a set of Java API for executing SQL statements. This API consists of a set of classes and interfaces to enable programs to write pure Java Database, applications. JDBC is a layer of abstraction that allows users to choose between databases. It allows you to change to a different database engine and to write to a single API. JDBC allows you to write database applications in Java without having to concern yourself with the underlying details of a particular database.<\/p>\n<p>JDBC standards for Java DataBase Connectivity. It is a specification given by Sun Microsystems and standards followed by X\/Open SAG (SQL Access Group) CLI (Call Level Interface) to interact with the DB.<\/p>\n<p>Java programming language methods. The JDBC API provides database-independent connectivity between the JAVA Applications and a wide range of tabular databases. JDBC technology allows an application component provider to:<\/p>\n<ul>\n<li>Perform connection and authentication to a database server<\/li>\n<li>Manage transactions<\/li>\n<li>Moves SQL statements to a database engine for preprocessing and execution<\/li>\n<li>Executes stored procedures<\/li>\n<li>Inspects and modifies the results from SELECT statements<\/li>\n<\/ul>\n<p>Question 2.<br \/>\nWhat is JDBC? What are its advantages?<br \/>\nAnswer:<br \/>\nIt is an API . The latest version of JDBC api is (3.0). The JDBC 3.0 API is divided into two packages:<\/p>\n<ol>\n<li>java.sql and<\/li>\n<li>javax.sql.<\/li>\n<\/ol>\n<p>Both packages are included in the J2SE and J2EE platforms.<br \/>\n<strong>Advantages:<\/strong><\/p>\n<ul>\n<li>The JDBC API can be used to interact with multiple data sources in a distributed, heterogeneous environment.<\/li>\n<li>It can connect to any of the databases from the java language.<\/li>\n<li>It can switch over to any backend database without changing java code or by minute changes.<\/li>\n<\/ul>\n<p>Question 3.<br \/>\nWhat is JDBC API and when do we use it?<br \/>\nAnswer:<br \/>\nJava DataBase Connectivity API allows us to work with relational databases. JDBC API interfaces and classes are part of java.sql and javax.sql packages. We can use JDBC API to get the database connection, run SQL queries and stored procedures in the database server, and process the results. JDBC API is written in a way to allow loose coupling between our Java program and actual JDBC drivers that make our life easier in switching from one database to another database servers easily.<\/p>\n<p>Question 4.<br \/>\nHow many JDBC Drivers are there? What are they?<br \/>\nAnswer:<br \/>\nThere are 4 types of JDBC drivers.<\/p>\n<ol>\n<li>JDBC-ODBC Bridge Driver (Type-1 driver)<\/li>\n<li>Native API Partly Java Driver (Type-2 driver)<\/li>\n<li>Net protocol pure Java Driver (Type-3 driver)<\/li>\n<li>Native protocol Pure Java Driver (Type-4 driver)<\/li>\n<\/ol>\n<p>Question 5.<br \/>\nWhat is the difference between JDBC and ODBC?<br \/>\nAnswer:<\/p>\n<ol>\n<li>OBDC is for Microsoft and JDBC is for Java applications.<\/li>\n<li>ODBC can\u2019t be directly used with Java because it uses a C interface.<\/li>\n<li>ODBC makes use of pointers that have been removed totally from Java.<\/li>\n<li>ODBC mixes simple and advanced features together and has complex options for simple queries. But JDBC is designed to keep things simple while allowing advanced capabilities when required.<\/li>\n<li>ODBC requires manual installation of the ODBC driver manager and driver on all client machines. JDBC drivers are written in Java and JDBC code is automatically installable, secure, and portable on all platforms.<\/li>\n<li>JDBC API is a natural Java interface and is built on ODBC. JDBC retains some of the basic features of ODBC.<\/li>\n<\/ol>\n<p>Question 6.<br \/>\nWhat are the types of JDBC Driver Models and explain them?<br \/>\nAnswer:<br \/>\nThere are two types of JDBC Driver Models and they are:<\/p>\n<ol>\n<li>Two-tier model and<\/li>\n<li>Three-tier model<\/li>\n<\/ol>\n<p><strong>1. Two-tier models:<\/strong> In this model, Java applications interact directly with<br \/>\nthe database. A JDBC driver is required to communicate with the particular database management system that is being accessed. SQL statements are sent to the database and the results are given to the user. This model is referred to as client\/server configuration where the user is the client and the machine that has the database is called the server.<\/p>\n<p><strong>2. Three-tier model:<\/strong> A middle tier is introduced in this model. The functions of this model are:<\/p>\n<ul>\n<li>Collection of SQL statements from the client and handing it over to the database,<\/li>\n<li>Receiving results from the database to the client and<\/li>\n<li>Maintaining control over accessing and updating the above.<\/li>\n<\/ul>\n<p>Question 7.<br \/>\nWhat are the steps involved in making a connection with a database or how do you connect to a database?<br \/>\nAnswer:<\/p>\n<p>a) Loading the driver: To load the driver, Class.forName( ) method is used.<\/p>\n<p><strong>Class.forName(\u201csun.jdbc.odbc.JdbcOdbcDriver\u201d);<\/strong><br \/>\nWhen the driver is loaded, it registers itself with java.sqLDriverManager class as an available database driver.<\/p>\n<p>b) Making a connection with database: To open a connection to a given database,<br \/>\nDriverManager.getConnection( ) method is used.<br \/>\nConnection con = DriverManager.getConnection (\u201cjdbc:odbc:somedb\u201d, \u201cuser\u201d, \u201cpassword\u201d);<\/p>\n<p>c) Executing SQL statements: To execute a SQL query, java.sql.statements class is used.<\/p>\n<p><strong>createStatement( ) method of Connection to obtain a new Statement object. Statement stmt = con.createStatement( );<\/strong><\/p>\n<p>A query that returns data can be executed using the executeQuery( ) method of Statement. This method xecutes the statement and returns a java.sql.ResultSet that encapsulates the retrieved data:<\/p>\n<p><strong>ResultSet rs = stmt.executeQuery(\u201cSELECT * FROM some table\u201d);<\/strong><\/p>\n<p>d) Process the results : ResultSet returns one row at a time. Next( ) method of ResultSet object can be called to move to the next row. The getString() and getObject( ) methods are used for retrieving column values:<\/p>\n<pre>while (rs.next( ) ) {\r\n        String event = rs.getString(\u201cevent\u201d);\r\n       object count = (Integer) rs.getObject(\u201ccount\u201d);\r\n}<\/pre>\n<p>Question 8.<br \/>\nWhat type of driver did you use in a project?<br \/>\nAnswer:<br \/>\nJDBC-ODBC Bridge driver (is a driver that uses native(C language) libraries and makes calls to an existing ODBC driver to access a database engine).<\/p>\n<p>Question 9.<br \/>\nWhat are the types of statements in JDBC?<br \/>\nAnswer:<br \/>\n<strong>Statement \u2014<\/strong> To be used createStatement( ) method for executing single SQL statement.<br \/>\n<strong>PreparedStatement \u2014<\/strong> To be used prepared statements( ) method for executing same SQL statement over and over.<br \/>\n<strong>CallableStatement\u2014<\/strong> To be used prepare Call( ) methods for multiple SQL statements over and over.<\/p>\n<p>Question 10.<br \/>\nWhat is stored procedure?<br \/>\nAnswer:<br \/>\nA stored procedure is a group of SQL statements that forms a logical unit and performs a particular task.<br \/>\nStored Procedures are used to encapsulate a set of operations or queries to execute on the database. Stored procedures can be compiled and executed with different parameters and results and may have any combination of input\/output parameters.<\/p>\n<p>Question 11.<br \/>\nHow to create and call stored procedures?<br \/>\nAnswer:<br \/>\nTo create stored procedures:<\/p>\n<pre>Create procedure name (specify in, out, and in-out parameters) \r\n         BEGIN\r\n         Any multiple SQL statements;\r\n         END;\r\n\r\n         To call stored procedures:\r\n         CallableStatement csmt = con.preparecall(\u201c{call procedure name(?,?)}\u201d);\r\n         csmt.registerOutParameter(column no., data type); \r\n        csmt.setInt(column no., column name)\r\ncsmt.execute( );<\/pre>\n<p>Question 12.<br \/>\nWhat is connection pooling? Is it advantageous?<br \/>\nAnswer:<br \/>\nA connection pooling is a methodology of reusing open connections. After finishing a transaction the connection is not closed but is put to the pool, and when a user requests a database connection the next time, he gets a pooled connection instead of a newly opened one. This greatly reduces the time to perform single database operations, because of avoiding heavyweight open\/close operations. It\u2019s recommended to use database connection pooling as widely as possible.<\/p>\n<p>Question 13.<br \/>\nWhat is Connection Pooling?<br \/>\nAnswer:<br \/>\nConnection pooling is a cache of database connections that are maintained in memory, so that the connections may be reuse.<br \/>\nConnection pooling is a place where a set of connections are kept and are used by the different programmers without creating connections to the database (it means there is a readymade connection available for the programmers where they can use). After using the connection he can send back that connection to the connection pool. The number of connections in the connection pool may vary.<\/p>\n<p>Question 14.<br \/>\nHow do you implement Connection Pooling?<br \/>\nAnswer:<br \/>\nConnection Pooling can be implemented in the following way.<\/p>\n<p>\u2022 A javax.sql.ConnectionPoolDataSource interface that serves as a resource manager connection factory for pooled java.sql.Connection objects. Each database vendors provide the implementation for that interface.<br \/>\nFor example, the oracle vendor\u2019s implementation is as follows:<\/p>\n<p><strong>oracle.jdbc.pool.oracleConnectionPoolDataSource Class.<\/strong><\/p>\n<p>\u2022 A javax.sql.PooledConnection interface encapsulates the physical connection for the database. Again, the vendor provides the implementation.<\/p>\n<p>Question 15.<br \/>\nWhat Class.forName( ) method will do?<br \/>\nAnswer:<br \/>\nClass.forName( ) is used to load the Driver class which is used to connect the application with the Database. Here Driver class is a Java class provided by the Database vendor.<\/p>\n<p>Question 16.<br \/>\nWhat is the difference between JDBC 1.0 and JDBC 2.0?<br \/>\nAnswer:<br \/>\nThe JDBC 2.0 API includes many new features in the java.sql package as well as the new Standard Extension package, javax.sql. This new JDBC API moves Java applications into the world of heavy-duty database computing. New features in the java.sql package include support for SQL3 data types, scrollable result sets, programmatic updates, and batch updates. The new JDBC Standard Extension API, an integral part of Enterprise JavaBeans (EJB) technology, allows you to write distributed transactions that use connection pooling, and it also makes it possible to connect to virtually any tabular data source, including files and spreadsheets.<br \/>\nThe JDBC 2.0 API includes many new features like<\/p>\n<ol>\n<li>Scrollable result sets<\/li>\n<li>Batch updates<\/li>\n<li>Connection Pooling<\/li>\n<li>Distributed transactions<\/li>\n<li>set auto-commit ( )<\/li>\n<\/ol>\n<p>Question 17.<br \/>\nWhich methods and classes are used for connection pooling?<br \/>\nAnswer:<br \/>\nJDBC provides an interface, which must be implemented by a JDBC driver supporting connection pooling. This interface is called ConnectionPoolDataSource. Most existing JDBC drivers (DataSource instances) implement this interface. It provides the following methods for obtaining PooledConnections:<br \/>\nPooledConnection getPooledConnection ( ) throws SQLException;<br \/>\nPooledConnection getPooledConnection (String user, String password) throws SQLException;<br \/>\nSuch connections can be closed by issuing connections. close( ), but it\u2019s only a logical closing, not physical. Physically, no connection is closed, it\u2019s just returned to the pool.<\/p>\n<p>Question 18.<br \/>\nWhat are the two major components of JDBC?<br \/>\nAnswer:<br \/>\nOne implementation interface for database manufacturers, the other implementation interface for application and applet writers.<\/p>\n<p>Question 19.<br \/>\nWhat is the JDBC Driver interface?<br \/>\nAnswer:<br \/>\nThe JDBC Driver interface provides vendor-specific implementations of the abstract classes provided by the JDBC API. Each vendor\u2019s driver must provide implementations of the java.sql.Connection, Statement, PreparedStatement, CallableStatement, ResultSet and Driver.<\/p>\n<p>Question 20.<br \/>\nWhat are the common tasks of JDBC?<br \/>\nAnswer:<\/p>\n<ul>\n<li>Create an instance of a JDBC driver or load JDBC drivers through jdbc.drivers<\/li>\n<li>Register a driver<\/li>\n<li>Specify a database<\/li>\n<li>Open a database connection<\/li>\n<li>Submit a query<\/li>\n<li>Receive results<\/li>\n<\/ul>\n<p>Question 21.<br \/>\nWhat packages are used by JDBC?<br \/>\nAnswer:<br \/>\nThere are 8 packages: java.sql.Driver, Connection,Statement, PreparedStatement, CallableStatement, ResultSet, ResultSetMetaData, DatabaseMetaData.<\/p>\n<p>Question 22.<br \/>\nWhat are the flow statements of JDBC?<br \/>\nAnswer:<br \/>\nA URL string &#8211; -&gt;getConnection- -&gt;DriverManager- -&gt;Driver- -&gt;Connection- -&gt;Statement&#8211;&gt;executeQuery- -&gt;ResultSet.<\/p>\n<p>Question 23.<br \/>\nWhat are the steps involved in establishing a connection?<br \/>\nAnswer:<br \/>\nThis involves two steps: (1) loading the driver and (2) making the connection.<\/p>\n<p>Question 24.<br \/>\nHow can you load the drivers?<br \/>\nAnswer:<br \/>\nLoading the driver or drivers you want to use is very simple and involves just one line of code. If, for example, you want to use the JDBC-ODBC Bridge driver, the following code will load it:<br \/>\nE.g.<\/p>\n<p><strong>Class.forName(\u201csun.jdbc.odbe.JdbcOdbcDriver\u201d);<\/strong><\/p>\n<p>Your driver documentation will give you the class name to use. For instance, if the class name is jdbc.DriverXYZ, you would load the driver with the following line of code: E.g. <strong>Class.forName(\u201cjdbc.DriverXYZ\u201d);<\/strong><\/p>\n<p>Question 25.<br \/>\nWhat Class.forName will do while loading drivers?<br \/>\nAnswer:<br \/>\nIt is used to create an instance of a driver and register it with the DriverManager. When you have loaded a driver, it is available for making a connection with a DBMS.<\/p>\n<p>Question 26.<br \/>\nHow can you make the connection?<br \/>\nAnswer:<br \/>\nEstablishing a connection is to have the appropriate driver connect to the DBMS. The following line of code illustrates the general idea:<br \/>\n<strong>E.g.<\/strong><br \/>\n<strong>String url = \u201cjdbc:odbc:Fred\u201d;<\/strong><br \/>\n<strong>Connection con = DriverManager.getConnection(url, \u201cFernanda\u201d, \u201cJ8\u201d);<\/strong><\/p>\n<p>Question 27.<br \/>\nHow can you create JDBC statements?<br \/>\nAnswer:<br \/>\nA Statement object is what sends your SQL statement to the DBMS. You simply create a Statement object and then execute it, supplying the appropriate execute method with the SQL statement you want to send. For a SELECT statement, the method to use is executeQuery. For statements that create or modify tables, the method to use is executeUpdate. E.g. It takes an instance of an active connection to create a Statement object. In the following example, we use our Connection object con to create the Statement object stmt:<\/p>\n<p><strong>Statement stmt = con.createStatement( );<\/strong><\/p>\n<p>Question 28.<br \/>\nHow can you retrieve data from the ResultSet?<br \/>\nAnswer:<br \/>\nFirst:<br \/>\nJDBC returns results in a ResultSet object, so we need to declare an instance of the class ResultSet to hold our results. The following code demonstrates declaring the ResultSet object rs.<br \/>\n<strong>E.g.<\/strong><br \/>\n<strong>ResultSet rs = stmt.executeQuery(\u201cSELECT COF_NAME, PRICE FROM COFFEES\u201d);<\/strong><br \/>\n<strong>Second:<\/strong><\/p>\n<p><strong>String s = rs.getString(\u201cCOF_NAME\u201d);<\/strong><\/p>\n<p>The method getString is invoked on the ResultSet object rs, so getString( ) will retrieve (get) the value stored in the column COF_NAME in the current row of rs.<\/p>\n<p>Question 29.<br \/>\nWhat are the different types of Statements?<br \/>\nAnswer:<br \/>\n1. Statement (use createStatement method) 2. PreparedStatement (Use prepareStatement method) and 3. CallableStatement (Use prepareCall)<\/p>\n<p>Question 30.<br \/>\nHow can you use PreparedStatement?<br \/>\nAnswer:<br \/>\nThis special type of statement is derived from the more general class, Statement. If you want to execute a Statement object many times, it will normally reduce execution time to use a PreparedStatement object instead. The advantage to this is that in most cases, this SQL statement will be sent to the DBMS right away, where it will be compiled. As a result, the PreparedStatement object contains not just an SQL statement, but an SQL statement that has been precompiled. This means that when the PreparedStatement is executed, the DBMS can just run the PreparedStatement\u2019s SQL statement without having to compile it first.<br \/>\n<strong>E.g.<\/strong><br \/>\n<strong>PreparedStatement updateSales = con.prepareStatement(\u201cUPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE?\u201d);<\/strong><\/p>\n<p>Question 31.<br \/>\nHow to call a Stored Procedure from JDBC?<br \/>\nAnswer:<br \/>\nThe first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure;<br \/>\n<strong>E.g.<\/strong><br \/>\n<strong>CallableStatement cs = con.prepareCall(\u201c{call SHOW_SUPPLIERS}\u201d); <\/strong><br \/>\n<strong>ResultSet rs = cs.executeQuery( );<\/strong><\/p>\n<p>Question 32.<br \/>\nHow to Retrieve Warnings?<br \/>\nAnswer:<br \/>\nSQLWarning objects are a subclass of SQLException that deal with database access warnings. Warnings do not stop the execution of an application, as exceptions do; they simply alert the user that something did not happen as planned. A warning can be reported on a Connection object, a Statement object (including PreparedStatement and CallableStatement objects), or a ResultSet object. Each of these classes has a get warnings method, which you must invoke in order to see the first warning reported on the calling object E.g.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">SQLWarning warning = stmt.getWarnings( );\r\nif (warning != null) {\r\nwhile (warning != null) {\r\nSystem.out.println(\u201cMessage: \u201c + warning.getMessage( ));\r\nSystem.out.println(\u201cSQLState: \u201c + warning.getSQLState( ));\r\nSystem.out.print(\u201cvendor error code: \u201c);\r\nSystem.out.println(warning.getErrorcode( )) ;\r\nwarning = warning.getNextwarning( );\r\n\r\n}\r\n}<\/pre>\n<p>Question 33.<br \/>\nHow to Make Updates to Updatable Result Sets?<br \/>\nAnswer:<br \/>\nAnother new feature in the JDBC 2.0 API is the ability to update rows in a result set using methods in the Java programming language rather than havings to send an SQL command. But before you can take advantage of this capability, you need to create a ResultSet object that is updatable. In order to do this, you supply the ResultSet constant CONCUR_UPDATABLE to the createStatement method.<br \/>\n<strong>E.g.<\/strong><br \/>\nConnection con = DriverManager.getConnection(\u201cjdbc:mySubprotocol:mySubNa me\u201d);<br \/>\nStatement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet. CONCURJJPD ATABLE);<br \/>\nResultSet uprs = (\u201cSELECT COF_NAME, PRICE FROM COFFEES\u201d);<\/p>\n<p>Question 34.<br \/>\nHow to Interact with DB?<br \/>\nAnswer:<br \/>\nGenerally, every DB vendor provides a User Interface through which we can easily execute SQL queries and gets the result (For example Oracle Query Manager for Oracle, and TOAD (www.quest.com) tool common to all the databases). And these tools will help DB developers to create databases. But as a programmer we want to interact with the DB dynamically to execute some SQL queries from our application (Any application like C, C++, JAVA, etc), and for this requirement, DB vendors provide some Native Libraries (Vendor Specific) using this we can interact with the DB i.e. If you want to execute some queries on Oracle DB, oracle vendor provides an OCI (Oracle Call Interface) Libraries to perform the same.<\/p>\n<p>Question 35.<br \/>\nWhat for JDBC?<br \/>\nAnswer:<br \/>\nAs we have studied ODBC and its advantages and came to know that it provides a common API to interact with any DB which has an ODBC Service Provider\u2019s Implementation written in Native API that can be used in your applications.<br \/>\nIf an application wants to interact with the DB then the options which have been explained up to now in this book are:<\/p>\n<ol>\n<li>Using Native Libraries given by the DB vendor<\/li>\n<li>Using ODBC API<\/li>\n<\/ol>\n<p>And we have listed their Advantages and Disadvantages.<br \/>\nBut if the application is a JAVA application then the above-given options are not recommended to be used due to the following reasons<br \/>\n1. Native Libraries given by DB vendor<\/p>\n<ul>\n<li>The application becomes vendor dependent and<\/li>\n<li>The application has to use JNI to interact with Native Lib which may cause serious problems for Platform Independency in our applications.<\/li>\n<\/ul>\n<p>2. And the second option given was using ODBC API which can solve the l.a problem but again this ODBC API is also a Native API, so we have to use JNI in our Java applications which leads to the l.b described problem. And the answer for these problems is JDBC (Java DataBase Connectivity) which provides a common Java API to interact with any DB.<\/p>\n<p>Question 36.<br \/>\nWhat is a transaction?<br \/>\nAnswer:<br \/>\nThe transaction is collection of logical operation that performs a task. The transaction should have ACID properties.<br \/>\nA for Atomicity<br \/>\nC for Consistency<br \/>\nI for Isolation<br \/>\nD for Durability.<br \/>\nA transaction can be termed as any operation such as storing, retrieving, updating, or deleting records in the table that hits the database.<\/p>\n<p>Question 37.<br \/>\nWhat is the purpose of setAutoCommit( )<br \/>\nAnswer:<br \/>\nIt is set as<br \/>\n<strong>ConnectionObject.setAutoComit( );<\/strong><br \/>\nAfter any updates, the program cannot be affected by the database. We have committed the transactions. For this purpose, we can set the AutoCommit flag to Connection Object.<\/p>\n<p>Question 38.<br \/>\nWhat is stored procedure? How do you create stored procedures?<br \/>\nAnswer:<br \/>\nStored procedures are a group of SQL statements that performs a logical unit and performs a particular task.<br \/>\nStored procedures are used to encapsulate a set of operations or queries to execute on data.<br \/>\nA stored procedure is a stored program in the database, PL\/SQL program is a Stored Procedure. Stored Procedures can be called from java by CallableStatement<\/p>\n<p>A precompiled collection of SQL statements stored under a name and processed as a unit.<br \/>\nStored procedures can:<\/p>\n<ol>\n<li>Accept input parameters and return multiple values in the form of output parameters to the calling procedure or batch.<\/li>\n<li>Contain programming statements that perform operations in the database, including calling other procedures.<\/li>\n<li>Return a status value to a calling procedure or batch to indicate success or failure (and the reason for failure).<\/li>\n<\/ol>\n<p>Question 39.<br \/>\nWhat are batch updates?<br \/>\nAnswer:<br \/>\nThe batch Update facility allows multiple update operations to be submitted to a database for processing at once. Using batch updates will improve the performance.<\/p>\n<p>Question 40.<br \/>\nWhat is the difference between Resultset and Rowset<br \/>\nAnswer:<br \/>\nA RowSet is a disconnected, serializable version of a JDBC ResultSet.<br \/>\nThe RowSet is different than other JDBC interfaces in that you can write a RowSet to be vendor-neutral. A third party could write a RowSet implementation that could be used with any JDBC-compliant database. The standard implementation supplied by Sun uses a ResultSet to read the rows from a database and then stores those rows as Row objects in a Vector inside the RowSet. In fact, a RowSet implementation could be written to get its data from any source. The only requirement is that the RowSet acts as if it was a ResultSet. Of course, there is no reason that a vendor couldn\u2019t write a RowSet implementation that is vendor-specific.<br \/>\nThe standard implementations have been designed to provide a fairly good range of functionality. The implementations provided are:<\/p>\n<p><strong>CachedRowSetlmpI &#8211;<\/strong> This is the implementation of the RowSet that is closest to the definition of RowSet functionality that we discussed earlier. There are two ways to load this RowSet. The execute ( ) method will load the RowSet using a Connection object. The populate( ) method will load the RowSet from a previously loaded ResultSet.<\/p>\n<p><strong>WebRowSetlmpl &#8211;<\/strong> This is very similar to the CachedRowSetlmpI (it is a child class) but it also includes methods for converting the rows into an XML document and loading the RowSet with an XML document. The XML document can come from any Stream or Reader\/Writer object. This could be especially useful for Web Services.<\/p>\n<p><strong> JdbcRowSetlmpl &#8211;<\/strong> This is a different style of implementation that is probably less useful in normal circumstances. The purpose of this RowSet is to make a ResultSet look like a JavaBean. It is not serializable and must maintain a connection to the database.<br \/>\nThe remaining two implementations are used with the first three implementations:<\/p>\n<p><strong>FilteredRowSetlmpl &#8211;<\/strong> This is used to filter data from an existing RowSet. The filter will skip records that don\u2019t match the criteria specified in the filter when a next( ) is used on the RowSet.<\/p>\n<p><strong>JoinRowSetlmpl &#8211;<\/strong> This is used to simulate a SQL join command between two or more RowSet objects.<\/p>\n<p>Question 41.<br \/>\nWhat are the steps for connecting to the database using JDBC Answer: Using DriverManager:<br \/>\n1. Load the driver class using class.forName(driver class) and Class.forName( ) loads the driver class and passes the control to DriverManager class<br \/>\n2. DriverManager.getConnectionO creates the connection to the database<\/p>\n<p><strong>Using DataSource:<\/strong><br \/>\nDataSource is used instead of DriverManager in Distributed Environment with the help of JNDI.<\/p>\n<ul>\n<li>Use JNDI to lookup the DataSource from the Naming service server.<\/li>\n<li>DataSource. getConnection method will return the Connection object to the database.<\/li>\n<\/ul>\n<p>Question 42.<br \/>\nWhat are the two major components of JDBC?<br \/>\nAnswer:<br \/>\nOne implementation interface for database manufacturers, the other implementation interface for application and applet writers.<\/p>\n<p>Question 43.<br \/>\nWhat is the JDBC Driver interface?<br \/>\nAnswer:<br \/>\nThe JDBC Driver interface provides vendor-specific implementations of the abstract classes provided by the JDBC API. Each vendor&#8217;s driver must provide implementations of the java.sql. Connection, Statement, PreparedStatement,<br \/>\nCallableStatement, ResultSet, and Driver.<\/p>\n<p>Question 44.<br \/>\nWhat are the common tasks of JDBC?<br \/>\nAnswer:<br \/>\nCreate an instance of a JDBC driver or load JDBC drivers through jdbc. drivers<br \/>\nRegister a driver<br \/>\nSpecify a database<br \/>\nOpen a database connection<br \/>\nSubmit a query<br \/>\nReceive results<\/p>\n<p>Question 45.<br \/>\nWhat are the steps involved in establishing a connection?<br \/>\nAnswer:<br \/>\nThis involves two steps:<\/p>\n<ol>\n<li>loading the driver and<\/li>\n<li>making the connection.<\/li>\n<\/ol>\n<p>Question 46.<br \/>\nWhat Class.forName will do while loading drivers?<br \/>\nAnswer:<br \/>\nIt is used to create an instance of a driver and register it with the DriverManager. When you have loaded a driver, it is available for making a connection with a DBMS.<\/p>\n<p>Question 47.<br \/>\nWhat are the different types of Statements?<br \/>\nAnswer:<\/p>\n<ol>\n<li>Create Statement: For a Simple statement used for the static query.<\/li>\n<li>Prepared Statement: For a runtime \/ dynamic query.Where String is a dynamic query you want to execute<\/li>\n<li>Callable Statement (Use prepare all): \/\/For Stored procedure Callable statement, where sql is stored procedure.<\/li>\n<\/ol>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">try {\r\nConnection conn = DriverManager.getConnection(\u201cURL\u201d,\u2019USER\u201d.\u201dPWD\u201d);\r\nstatement stmt = conn.createstatement( );\r\nPreparedstatement pstmt = conn.preparestatementfstring sql);\r\nCallableStatement cstmt = conn.prepareCall(String sql);\r\n}\r\ncatch (SQLException ee)\r\n{\r\nee. pri ntStackTrace( );\r\n}<\/pre>\n<p>Don\u2019t forget all the above statements will throw the SQLException, so we need to use try-catch for the same to handle the exception.<\/p>\n<p>Question 48.<br \/>\nHow can you use PreparedStatement?<br \/>\nAnswer:<br \/>\nThis special type of statement is derived from the more general class, Statement. If you want to execute a Statement object many times, it will normally reduce execution time to use a Prepared statement object instead. The advantage to this is that in most cases, this SQL statement will be sent to the DBMS right away, where it will be compiled. As a result, the Prepared statement object contains not just an SQL statement, but an SQL statement that has been precompiled. This means that when the Prepared statement is executed, the DBMS can just run the PreparedStatement\u2019s SQL statement without having to compile it first.<br \/>\n<strong>E.g. Preparedstatement updateSales = con.prepareStatement(\u201cUPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ?\u201d);<\/strong><\/p>\n<p>Question 49.<br \/>\nHow to call a Stored Procedure from JDBC?<br \/>\nAnswer:<br \/>\nThe first step is to create a CallableStatement. object. As with Statement and Prepared statement objects, this is done with an open Connection object. A<\/p>\n<p>CaUableStatement object contains a call to a stored procedure;<br \/>\n<strong>E.g.<\/strong><br \/>\n<strong>CaUableStatement cs = con.prepareCall(\u201c{call SHOW_SUPPLIERS}\u201d);<\/strong><br \/>\nResultSet rs = cs.executeQuery( );<\/p>\n<p>Question 50.<br \/>\nExplain about JDBC-ODBC driver (Type-1)? When this type of driver is used?<br \/>\nAnswer:<br \/>\nIn this mechanism, the flow of execution will be<br \/>\nJava code(JDBC API)&lt;&#8212;&#8212;&#8212;-&gt;JDBC-ODBC bridge driver&lt;&#8212;&#8212;&#8212;-&gt;ODBC API&lt;&#8212;&#8212;&#8212;&#8211;&gt;ODBC Layer&lt;&#8212;&#8212;&#8212;-&gt;DataBase<br \/>\nThis type of JDBC Drivers provides a bridge between JDBC API and ODBC API.<\/p>\n<p><strong>Type-1: JDBC-ODBC Bridge Driver:<\/strong><br \/>\nSince ODBC is written in C-language using pointers, so JAVA doesn\u2019t support pointers, a java program can\u2019t communicate directly with the Database. The JDBC- ODBC bridge driver translates JDBC API calls to ODBC API calls.<\/p>\n<p><strong>Architecture<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-15249\" src=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png\" alt=\"Java Database Connectivity (JDBC) Interview Questions in Java chapter 14 img 1\" width=\"539\" height=\"230\" srcset=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png 539w, https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1-300x128.png 300w\" sizes=\"(max-width: 539px) 100vw, 539px\" \/><\/p>\n<p>This type of Driver is designed to convert the JDBC request call to ODBC call and ODBC response call to JDBC call.<br \/>\nThe JDBC uses this interface in order to communicate with the database, so neither the database nor the middle tier needs to be Java compliant. However, ODBC binary code must be installed on each client machine that uses this driver. This bridge driver uses a configured data source.<\/p>\n<p><strong>Advantages<\/strong><\/p>\n<ul>\n<li>Simple to use because ODBC drivers come with DB installation\/Microsoft front\/ back office product installation<\/li>\n<li>JDBC ODBC Drivers comes with JDK software<\/li>\n<\/ul>\n<p><strong>Disadvantages<\/strong><\/p>\n<ul>\n<li>More layers between the application and DB. And more API conversions lead to the downfall of the performance.<\/li>\n<li>Slower than the type-2 driver<\/li>\n<\/ul>\n<p><strong>Where to use it?<\/strong><br \/>\nThis type of driver is generally used at the development time to test your applications. Because of the disadvantages listed above, it is not used at production time. But if we are not available with any other type of driver implementations for a DB then we are forced to use this type of driver (for example <strong>Microsoft Access<\/strong>).<\/p>\n<p><strong>Examples of this type o\u00a3 drivers <\/strong><br \/>\n<strong>JdbcOdbcDriver from sun<\/strong><br \/>\nSun\u2019s JdbcOdbcDriver is one of the type-1 drivers and comes along with sun j2sdk (JDK).<\/p>\n<p><strong>Setting environment to use this driver<\/strong><\/p>\n<ol>\n<li>Software<br \/>\nODBC libraries have to be installed.<\/li>\n<li>classpath<br \/>\nNo additional classpath settings are required apart from the runtime jar (c:\\ j2sdkl.4\\jre\\lib\\rt.jar) which is default configured.<\/li>\n<li>Path No additional path configuration is required.<\/li>\n<\/ol>\n<p>How to use this driver<br \/>\n\u2022 Driver class name \u25a1 sun.jdbc.odbc.JdbcOdbcDriver<br \/>\n\u2022 Driver URL \u25a1 dbc:odbc:&lt;DSN&gt;<br \/>\nhere &lt;DSN&gt; (Data Source Name) is an ODBC data source name that is used by the ODBC driver to locate one of the ODBC Service Provider implementation APIs which can, in turn, connect to DB.<\/p>\n<p><strong>Steps to create &lt;DSN&gt;<\/strong><\/p>\n<p>\u2022 Run \u2018Data Sources (ODBC)\u2019 from Control PanelXAdministrative Tools\\ (for Windows 2000 server\/2000 professional\/XP) run \u2018ODBC Data Sources\u2019 from Control Panel\\<\/p>\n<p>\u2022 Click on Add button available on the above-displayed screen. This opens a new window titled \u2018Create New Data Source\u2019 which displays all the available DB\u2019s label DB\u2019s ODBC drivers currently installed on your system.<\/p>\n<p>\u2022 Select the suitable driver and click on Finish<\/p>\n<p>\u2022 Give the required info to the driver (like username, service id, etc)<\/p>\n<p>Question 51.<br \/>\nExplain about Type-2 driver? When this type of driver is used?<br \/>\nAnswer:<br \/>\nThe Drivers which are written in Native code will come into this category In this mechanism the flow of Execution will be<br \/>\nJava code (JDBC API) &lt;&#8212;&#8212;&#8211;&gt;Type-2 driver (JDBC driver) &lt;&#8212;&#8212;&#8211;&gt;Native API<br \/>\n(vendor specific) &lt;&#8212;&#8212;-&gt;Database<br \/>\nWhen a database call is made using JDBC, the driver translates the request into vendor-specific API calls.<\/p>\n<p>The database will process the request and sends the results back through the Native API, which will forward them back to the JDBC driver. The JDBC driver will format the results to conform to the JDBC standard and return them to the application.<\/p>\n<p><strong>Type-2 : Native API Partly JAVA Driver (Thick Driver) :<\/strong><br \/>\nJDBC Database calls are translated into Vendor-specific API calls. The database will process the request and send the results back through API to JDBC Driver &#8211; this will translate the results to the JDBC standard and return them to the Java application.<br \/>\nThe Vendor-specific language API must be installed on every client that runs the JAVA application.<br \/>\n<strong>Architecture:<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-15258\" src=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-2.png\" alt=\"Java Database Connectivity (JDBC) Interview Questions in Java chapter 14 img 2\" width=\"672\" height=\"202\" srcset=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-2.png 672w, https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-2-300x90.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/p>\n<p>This driver converts the JDBC call given by the Java application to a DB-specific native call (i.e. to C or C++) using JNI (Java Native Interface).<br \/>\n<strong>Advantages:<\/strong> Faster than the other types of drivers due to native library participation in socket programming.<br \/>\n<strong>Disadvantage:<\/strong> DB-specific native client library has to be installed in the client machine.<\/p>\n<p>\u2022 Preferably work in local network environment because network service name must be configured in client system &#8216;<\/p>\n<p><strong>Where to use it?<\/strong><br \/>\nThis type of driver is suitable to be used in server-side applications.<br \/>\nNot recommended to use with the applications using two tire models (i.e. the client and database layers) because in this type of model client used to interact with DB using the driver and in such a situation the client system should have the DB native library.<br \/>\n<strong>Examples of this type of drivers<\/strong><\/p>\n<p>1. OCI 8 (Oracle Call Interface) for Oracle implemented by Oracle Corporation.<br \/>\n<strong>Setting environment to use this driver<\/strong><\/p>\n<p>\u2666 Software: Oracle client software has to be installed in the client machine<br \/>\n\u2666 classpath -&gt; %ORACLE_HOME%\\ora8l\\jdbc\\lib\\classeslll.zip<br \/>\n\u2666 path %ORACLE_HOME%\\ora81\\bin How to use this driver?<br \/>\n\u2666 Driver class name -&gt; oracle.jdbc.driver.OracleDriver<br \/>\n\u2666 Driver URL -&gt; jdbc:oracle:oci8:@TNSName<\/p>\n<p><strong>Note:<\/strong> TNS Names of Oracle is available in Oracle installed folder %ORACLE_ HOME%\\Ora8 l\\network\\admin\\tnsnames.ora<\/p>\n<p>2. Weblogic Jdriver for Oracle implemented by BEA Weblogic:<\/p>\n<p><strong>Setting environment to use this driver<\/strong><br \/>\n\u2666 Oracle client software has to be installed in the client machine<br \/>\n\u2666 weblogic dll\u2019s has to be set in the path<br \/>\n\u2666 classpath -&gt; d:\\bea\\weblogic700\\server\\lib\\webiogic.jar<br \/>\n\u2666 path -&gt; %ORACLE_HOME%\\ora81\\bin; d:\\bea\\weblogic700\\server\\ bin\\&lt;subfolder&gt;&lt;sub folder&gt; is<br \/>\n\u2666 oci817_8 if you are using Oracle 8.1.x<br \/>\n\u2666 oci901_8 for Oracle 9.0.x<br \/>\n\u2666 oci920_8 for Oracle 9.2.x<\/p>\n<p><strong>How to use this driver<\/strong><br \/>\n\u2666 <strong>Driver class name -&gt;<\/strong> weblogic.jdbc.oci.Driver<br \/>\n\u2666<strong> Driver URL-&gt;<\/strong> jdbc:weblogic:oracle:HostName<\/p>\n<p>Question 52.<br \/>\nExplain about Type-3 driver? When this type of driver is used?<br \/>\nAnswer:<br \/>\nIn this mechanism, the flow of Execution will be Java code (JDBC API) &lt;&#8212;&#8212;-&gt; JDBC driver &lt;&#8212;&#8212;-&gt; JDBC driver server &lt;&#8212;&#8212;&gt;<br \/>\nNative driver &lt;&#8212;&#8212;&#8211;&gt; Database<br \/>\nThe Java Client Application sends the calls to the Intermediate data access server(JDBC driver server)<br \/>\nThe middle tier then handles the request using another driver (Type-II or Type-IV drivers) to complete the request.<\/p>\n<p><strong>Type-3 Intermediate Database Access Server:<\/strong><\/p>\n<p>Type-3 Driver uses an Intermediate (middleware) database driver that has the ability to connect multiple JAVA clients to multiple database servers. A client connects to the database server via an Intermediate server component (such as a listener) that acts as a gateway for multiple database servers.<br \/>\nBea WebLogic includes Type-3 Driver.<br \/>\n<strong>Architecture:<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-15262\" src=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-3.png\" alt=\"Java Database Connectivity (JDBC) Interview Questions in Java chapter 14 img 3\" width=\"551\" height=\"163\" srcset=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-3.png 551w, https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-3-300x89.png 300w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/p>\n<p>This type of driver\u2019s responsibility is to convert JDBC call to Net protocol (Middleware listener dependent) format and redirect the client request to Middleware Listener and middleware listener, in turn, uses type-1, type-2, or type-4 driver to interact with DB.<\/p>\n<p><strong>Advantages:<\/strong><\/p>\n<ul>\n<li>It allows flexibility in the architecture of the application.<\/li>\n<li>In absence of a DB vendor-supplied driver we can use this driver<\/li>\n<li>Suitable for Applet clients to connect DB because it uses Java libraries for communication between client and server.<\/li>\n<\/ul>\n<p><strong>Disadvantages:<\/strong><\/p>\n<p>\u2022 From client to server communication this driver uses Java libraries, but from server to DB connectivity this driver uses native libraries, hence a number of API conversions and a layer of interactions increases to perform operations that lead to a performance deficit.<br \/>\n\u2022 Third-party vendor dependent and this driver may not provide a suitable driver for all DBs<\/p>\n<p><strong>Where to use it?<\/strong><br \/>\n\u2022 Suitable for Applets when connecting to databases<br \/>\n<strong>Examples of this type of driver:<\/strong><br \/>\n1. IDS Server (Intersolv) driver available for most of the Databases<br \/>\n<strong>Setting environment to use this driver<\/strong><br \/>\n\u2022 Software: IDS software is required to be downloaded from the following URL<br \/>\n[http:\/\/www.idssoftware.com\/idsserver.html -&gt; Export Evaluation]<br \/>\n\u2022 classpath -&gt; C:\\IDSServer\\classes\\jdkl4drv.jar<br \/>\n\u2022 path -&gt;<br \/>\nHow to use this driver?<br \/>\n\u2022 Driver class name -&gt; ids.sql.IDSDriver<br \/>\n\u2022 Driver URL jdbc:ids:\/\/localhost:12\/conn?dsn=\u2019IDSExamples\u2019<br \/>\nNote: DSN Name must be created in ServerDSN<\/p>\n<p>Question 53.<br \/>\nExplain about Type-4 driver? When this type of driver is used?<br \/>\nAnswer:<br \/>\nThis is a pure java driver (alternative to Type-II drivers).<br \/>\nIn this mechanism, the flow of Execution will be<br \/>\nJava code (JDBC API) &lt;&#8212;&#8212;&#8211;&gt;Type-4 driver (JDBC driver) &lt;&#8212;&#8212;&#8211;&gt; Database<br \/>\nThese types of drivers convert the JDBC API calls to direct network calls using vendor-specific networking protocol by making direct socket connections with the database.<br \/>\n<strong>Examples of this type of driver are<\/strong><\/p>\n<ol>\n<li>Tabular Data Stream for Sybase<\/li>\n<li>Oracle Thin JDBC driver for Oracle<\/li>\n<\/ol>\n<p><strong>Type-4 Pure JAVA Driver (Thin driver):<\/strong><br \/>\nType-4 Driver translates JDBC-API calls to direct network calls using vendor-specific networking protocols by making direct server connections with the database.<br \/>\n<strong>Architecture<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-15264\" src=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-4.png\" alt=\"Java Database Connectivity (JDBC) Interview Questions in Java chapter 14 img 4\" width=\"599\" height=\"157\" srcset=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-4.png 599w, https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-4-300x79.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/p>\n<p>This type of driver converts the JDBC call to a DB-defined native protocol.<\/p>\n<p><strong>Advantage<\/strong><\/p>\n<ul>\n<li>Type-4 driver is simple to deploy since there are No client native libraries required to be installed in the client machine<\/li>\n<li>Comes with most of the Databases<\/li>\n<\/ul>\n<p><strong>Disadvantages:<\/strong><\/p>\n<ul>\n<li>Slower in execution compared with other JDBC Driver due to Java libraries are used in socket communication with the DB<\/li>\n<\/ul>\n<p><strong>Where to use?<\/strong><\/p>\n<p>\u2022 This type of driver is suitable to be used with server-side applications, client-side applications,s, and Java Applets also.<br \/>\n<strong>Examples of this type of drivers<\/strong><\/p>\n<p>1) Thin driver for Oracle implemented by Oracle Corporation<\/p>\n<p><strong>Setting environment to use this driver<\/strong><br \/>\n\u2666 classpath -&gt; %ORACLE_HOME%\\ora81\\jdbc\\hb\\classeslll.zip<\/p>\n<p><strong>How to use this driver<\/strong><br \/>\n\u2666 Driver class name oracle.jdbc.driver.OracleDriver<br \/>\n\u2666 Driver URL -&gt; jdbc:oracle:thifi:@HostName:&lt;port no&gt;:&lt;SID&gt;<\/p>\n<p>&lt;port no&gt; -&gt;1521<br \/>\n&lt;SID&gt; -&gt; ORCL<\/p>\n<p>2) MySQL Jconnector for MySQL database<\/p>\n<p><strong>Setting environment to use this driver<\/strong><br \/>\n\u2666 classpath -&gt; C:\\mysql\\mysql-connector-java-3.0.8-stable\\mysql- connector-java-3.0.8-stable-bin.jar<br \/>\n<strong>How to use this driver<\/strong><br \/>\n\u2666 Driver class name -&gt; com.mysqbjdbc.Driver<br \/>\n\u2666 Driver URL -&gt; jdbc:mysql:\/\/\/test<\/p>\n<p>Question 54.<br \/>\nHow JDBC API is common to all the Databases and also to all drivers?<br \/>\nAnswer:<br \/>\nFine! The answer is JDBC API uses Factory Method and <a href=\"https:\/\/btechgeeks.com\/abstract-factory-design-pattern\/\">Abstract Factory Design pattern<\/a> implementations to make API common to all the Databases and Drivers. In fact, most of the classes available in JDBC API are interfaces, where Driver vendors must provide the implementation for the above-said interfaces.<\/p>\n<p>Question 55.<br \/>\nThen how JDBC developers can remember or find out the syntaxes of vendor-specific classes?<br \/>\nAnswer:<br \/>\nNo! developer need not have to find out the syntaxes of vendor-specific implementations why because DriverManager is one named class available in JDBC API into which if you register Driver class name, URL, user, and password, DriverManager class in-turn brings us one Connection object.<\/p>\n<p>Question 56.<br \/>\nWhy most of the classes given in JDBC API are interfaces?<br \/>\nAnswer:<br \/>\nAbstract class forces all subclasses to implement common methods whichever are required implementations. Only abstract methods and classes can do this job. That&#8217;s why most part of the JDBC API is a formation of interfaces.<\/p>\n<p>Question 57.<br \/>\nWhich Driver is preferable for using JDBC API in Applets?<br \/>\nAnswer:<br \/>\nType-4 Drivers.<\/p>\n<p>Question 58.<br \/>\nWrite the Syntax of the URL to get a connection? Explain?<br \/>\nAnswer:<br \/>\n<strong>Syntax:<\/strong> jdbc:&lt;subprotocal&gt;:&lt;subname&gt;<br \/>\n<strong>jdbc:<\/strong> is a protocol.This is the only allowed protocol in JDBC.<br \/>\n<strong>&lt;subprotocal&gt;:<\/strong> The subprotocol is used to identify a database driver, or the name of the database connectivity mechanism, chosen by the database driver providers.<br \/>\n<strong>&lt;subname&gt;:<\/strong> The syntax of the surname is driver-specific. The driver may choose any syntax appropriate for its implementation<br \/>\nEx: jdbc:odbc:dsn<br \/>\njdbc:oracle:oci8:@ database name.<br \/>\njdbc:orale:thin:@ database name:port number:SID<\/p>\n<p>Question 59.<br \/>\nHow do u Load a driver?<br \/>\nAnswer:<br \/>\nUsing Driver Class.forName(java.lang.String driverclass) or registerDriver(Driver driver) .<\/p>\n<p>Question 60.<br \/>\nWhat are the types of resultsets in JDBC3.0? How you can retrieve information on the resultset?<br \/>\nAnswer:<br \/>\nScroUableResultSet and ResultSet. We can retrieve information of resultset by using java.sql.ResultSetMetaData interface. You can get the instance by calling the method getMetaData( ) on the ResulSet object.<\/p>\n<p>Question 61.<br \/>\nCan java objects be stored in the database? How?<br \/>\nAnswer:<br \/>\nYes. We can store java objects, BY using setObject( ),setBlob( ) and setClob( ) methods in PreparedStatement<\/p>\n<p>Question 62.<br \/>\nWhat do u mean by isolation level?<br \/>\nAnswer:<br \/>\nIsolation means that the business logic can proceed without consideration for the other activities of the system.<\/p>\n<p>Question 63.<br \/>\nHow do u set the isolation level?<br \/>\nAnswer:<br \/>\nBy using set transaction isolation(int level) in java.sql.Connection interface. level MEAnswer:-<br \/>\nstatic final int TRANSACTION_READ_UNCOMMITTED \/\/cannot prevent any reads.<br \/>\nstatic final int TRANSACTION_READ_COMMITTED \/\/prevents dirty reads static final int TRANSACTION_REPEATABLE_READ \/\/prevents dirty reads &amp; non-repeatable read.<br \/>\nstatic final int TRANSACTION_SERIALIZABLE \/\/prevents dirty reads, non-repeatable read &amp; phantom read.<br \/>\nThese are the static final fields in java.sql.Connection interface.<\/p>\n<p>Question 64.<br \/>\nWhat is a dirty read?<br \/>\nAnswer:<br \/>\nA Dirty read allows a row changed by one transaction to be read by another transaction before any change in the row has been committed. This problem can be solved by setting the transaction isolation level to TRANSACTION_READ_ COMMITTED<\/p>\n<p>Question 65.<br \/>\nWhat is a non-repeatable read?<br \/>\nAnswer:<br \/>\nA non-repeatable read is where one transaction reads a row, a second transaction alters or deletes the row, and the first transaction re-reads the row, getting different values the second time. This problem can be solved by setting the transaction isolation level to TRANSACTION_REPEATABLE_READ<\/p>\n<p>Question 66.<br \/>\nWhat is phantom read?<br \/>\nAnswer:<br \/>\nA phantom read is where one transaction reads all rows that satisfy a WHERE condition, a second transaction inserts a row that satisfies that WHERE condition and the first transaction re-reads for the same condition, retrieving the additional \u2018phantom\u2019 row in the second read This problem can be solved by setting the transaction isolation level to TRANSACTION_SERIALIZABLE<\/p>\n<p>Question 67.<br \/>\nWhat is the difference between java.sql.Statement &amp; java.sql. PreparedStatement?<br \/>\nAnswer:<br \/>\nwrite the appropriate situations to use these statements?<\/p>\n<p>Question 68.<br \/>\nHow to retrieve the information about the database?<br \/>\nAnswer:<br \/>\nWe can retrieve the info about the database by using interface java.sql. DatabaseMetaData we can get this object by using getMetaData( ) method in Connection interface.<\/p>\n<p>Question 69.<br \/>\nWhat are the Different types of exceptions in jdbc?<br \/>\nAnswer:<br \/>\nBatchUpdateException<br \/>\nDataTruncation<br \/>\nSQLException<br \/>\nSQLWarning<\/p>\n<p>Question 70.<br \/>\nHow to execute no of queries at one go?<br \/>\nAnswer:<br \/>\nBy using a batch update (ie throw addBAtch( ) and executeBatch( )) in java.sql-Statement interface,or by using procedures.<\/p>\n<p>Question 71.<br \/>\nWhat are the advantages of the connection pool?<br \/>\nAnswer:<br \/>\nPerformance<\/p>\n<p>Question 72.<br \/>\nIn which interface the methods commit( ) &amp; rollback( ) are defined ?<br \/>\nAnswer:<br \/>\njava.sql.Connection interface<\/p>\n<p>Question 73.<br \/>\nHow to store images in a database?<br \/>\nAnswer:<br \/>\nUsing binary streams (i.e. getBinaryStream( ), setBinaryStream( )). But it is not visible in the database; it is stored in form of bytes, to make it visible we have to use anyone frontend tool.<\/p>\n<p>Question 74.<br \/>\nHow to check the null value in JDBC?<br \/>\nAnswer:<br \/>\nBy using the method was null( ) in ResultSet, it returns a boolean value. Returns, whether the last column read, had a value of SQL NULL.<br \/>\nNote that you must first call one of the getXXX( ) methods on a column to try to read its value and then call the method was null to see if the value read was SQL NULL.<\/p>\n<p>Question 75.<br \/>\nGive one example of a static Synchronized method in JDBC API?<br \/>\nAnswer:<br \/>\nget connection( ) method in DriverManager class. Which is used to get the object of the Connection interface.<\/p>\n<p>Question 76.<br \/>\nWhat is a Connection?<br \/>\nAnswer:<br \/>\nConnection is an interface that is used to make a connection between client and Database (i.e. opening a session with a particular database).<\/p>\n<p>Question 77.<br \/>\nWhat is the difference between execute( ), executeUpdate( ) and executeQuery( ) ? Where we will use them?<br \/>\nAnswer:<br \/>\nexecute( ) method returns a boolean value (ie if the given query returns a resultset then it returns true else false), so depending upon the return value we can get the ResultSet object (getResultsetO)or we can know how many rows have been affected by our query (getUpdateCount( ))-That is we can use this method for Fetching queries and Non-Fetching queries. Fetching queries are the queries that are used to fetch the records from the database (i.e. which returns a resultset) ex: Select * from emp.<\/p>\n<p>Non-Fetching queries are the queries that are used to update,insert, create or<br \/>\ndelete the records from the database<br \/>\nEx: update emp set sal=10000 where empno=7809.<br \/>\nexecute Update( ) method is used for non-fetching queries, which returns an int value. executeQuery( ) method is used for fetching queries which return ResulSet object.Which contains methods to fetch the values.<\/p>\n<p>Question 78.<br \/>\nWhat is the difference between JDBC and ODBC?<br \/>\nAnswer:<br \/>\na) OBDC is for Microsoft and JDBC is for Java applications.<br \/>\nb) ODBC can\u2019t be directly used with Java because it uses a C interface.<br \/>\nc) ODBC makes use of pointers that have been removed totally from Java.<br \/>\nd) ODBC mixes simple and advanced features together and has complex options for simple queries. But JDBC is designed to keep things simple while allowing advanced capabilities when required.<br \/>\ne) ODBC requires manual installation of the ODBC driver manager and driver on all client machines. JDBC drivers are written in Java and JDBC code is automatically installable, secure, and portable on all platforms.<br \/>\nf) JDBC API is a natural Java interface and is built on ODBC. JDBC retains some of the basic features of ODBC.<\/p>\n<p>Question 79.<br \/>\nWhat are the steps involved in making a connection with a database or how do you connect to a database?<br \/>\nAnswer:<br \/>\na) Loading the driver: To load the driver, Class.forName() method is used. Class.forName(\u201csun.jdbc.odbc.JdbcOdbcDriver\u201d);<br \/>\nWhen the driver is loaded, it registers itself with the java.sql.DriverManager class as an available database driver.<\/p>\n<p>b) Making a connection with database: To open a connection to a given database, DriverManager.getConnection() method is used.<br \/>\nConnection con = DriverManager.getConnection (\u201cjdbc:odbc:somedb\u201d. \u201cuser\u201d, \u201cpassword\u201d);<\/p>\n<p>c) Executing SQL statements: To execute a SQL query, java.sql.Statement class is used.<br \/>\ncreateStatement() method of Connection to obtain a new Statement object. Statement stmt = con.createStatement();<\/p>\n<p>d) A query that returns data can be executed using the executeQuery() method of Statement. This method executes the statement and returns a java.sql. ResultSet that encapsulates the retrieved data:<br \/>\nResultSet rs = stmt.executeQuery(\u201cSELECT * FROM some table\u201d);<\/p>\n<p>e) Process the results: ResultSet returns one row at a time. next( ) method of ResultSet object can be called to move to the next row. The getString() and getObject() methods are used for retrieving column values:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">while(rs.next( ) ) {\r\nString event = rs.getString(\u201cevent\u201d);\r\nobject count = (integer) rs.getobject(\u201ccount\u201d);\r\n}<\/pre>\n<p>Question 80.<br \/>\nWhat type of driver did you use in the project?<br \/>\nAnswer:<br \/>\nJDBC-ODBC Bridge driver (is a driver that uses native(C language) libraries and makes calls to an existing ODBC driver to access a database engine).<\/p>\n<p>Question 81.<br \/>\nWhat are the types of statements in JDBC?<br \/>\nAnswer:<br \/>\n<strong>Statement:<\/strong> To be used createStatementO method for executing single SQL statement<br \/>\n<strong>PreparedStatement:<\/strong> To be used preparedStatement( ) method for executing same SQL statement over and over<br \/>\n<strong>CallableStatement:<\/strong> To be used prepareCall( ) method for multiple SQL statements over and over<\/p>\n<p>Question 82.<br \/>\nWhat is stored procedure?<br \/>\nAnswer:<br \/>\nA stored procedure is a group of SQL statements that forms a logical unit and performs a particular task. Stored Procedures are used to encapsulate a set of operations or queries to execute on the database. Stored procedures can be compiled and executed with different parameters and results and may have any combination of input\/output parameters.<\/p>\n<p>Question 83.<br \/>\nWhat\u2019s the JDBC 2.0 API?<br \/>\nAnswer:<br \/>\nThe JDBC 2.0 API is the latest update of the JDBC API. It contains many new features, including scrollable result sets and the new SQL: 1999 (formerly SQL<br \/>\n3) data types. There are two parts to the JDBC 2.0 API: the JDBC 2.0 core API (the java.sql package), which is included in the Java TM 2 SDK, Standard Edition the JDBC 2.0 Optional Package API (the javax.sql package), which is available separately or as part of the Java 2 SDK, Enterprise Edition.<\/p>\n<p>Question 84.<br \/>\nDoes the JDBC-ODBC Bridge support the new features in the JDBC 2.0 API?<br \/>\nAnswer:<br \/>\nNo, the JDBC-ODBC Bridge that is included in the Java 2 Platform initial release does not support the new features in the JDBC 2.0 API. However, Sun and Merant are working to produce a new version of the Bridge that does support the new features. Note that we do not recommend using the Bridge except for experimental purposes or when you have no other driver available.<\/p>\n<p>Question 85.<br \/>\nCan the JDBC-ODBC Bridge be used with applets?<br \/>\nAnswer:<br \/>\nUse of the JDBC-ODBC bridge from an untrusted applet running in a browser, such as Netscape Navigator, isn\u2019t allowed. The JDBC-ODBC bridge doesn\u2019t allow untrusted code to call it for security reasons. This is good because it means that an untrusted applet that is downloaded by the browser can\u2019t circumvent Java security by calling ODBC. Remember that ODBC is native code, so once ODBC is called, the Java programming language can\u2019t guarantee that a security violation won\u2019t occur. On the other hand, Pure Java JDBC drivers work well with applets.<\/p>\n<p>They are fully downloadable and do not require any client-side configuration. Finally, we would like to note that it is possible to use the JDBC-ODBC bridge with applets that will be run in applet viewer since applet viewer assumes that applets are trusted. It is also possible to use the JDBC-ODBC bridge with applets that are run in the HotJavaTM browser (available from Java Software) since Hot Java provides an option to turn off applet security. In general, it is dangerous to turn applet security off, but it may be appropriate in certain controlled situations, such as for applets that will only be used in a secure intranet environment. Remember to exercise caution if you choose this option, and use an all-Java JDBC driver whenever possible to avoid security problems.<\/p>\n<p>Question 86.<br \/>\nHow do I start debugging problems related to the JDBC API?<br \/>\nAnswer:<br \/>\nA good way to find out what JDBC calls are doing is to enable JDBC tracing. The JDBC trace contains a detailed listing of the activity occurring in the system that is related to JDBC operations.<\/p>\n<p>If you use the DriverManager facility to establish your database connection, you use the DriverManager.setLogWriter method to enable tracing of JDBC operations. If you use a DataSource object to get a connection, you use the DataSource. setLogWriter method to enable tracing. (For pooled connections, you use the ConnectionPoolDataSource.setLogWriter method, and form connections that can participate in distributed transactions, you use the XADataSource.setLogWriter method.)<\/p>\n<p>Question 87.<br \/>\nHow can I use the JDBC API to access a desktop database like Microsoft Access over the network?<br \/>\nAnswer:<br \/>\nMost desktop databases currently require a JDBC solution that uses ODBC underneath. This is because the vendors of these database products haven\u2019t implemented all Java JDBC drivers.<\/p>\n<p>The best approach is to use a commercial JDBC driver that supports ODBC and the database you want to use. See the JDBC driver\u2019s page for a first of available JDBC drivers.<\/p>\n<p>The JDBC-ODBC bridge from Sun\u2019s Java Software does not provide network access to desktop databases by itself. The JDBC-ODBC bridge loads ODBC as a local DLL, and typical ODBC drivers for desktop databases like Access aren\u2019t networked. The JDBC-ODBC bridge can be used together with the RMI-JDBC bridge, however, to access a desktop database like Access over the net. This RMI-JDBC-ODBC solution is free.<\/p>\n<p>Question 88.<br \/>\nDoes the JDK include the JDBC API and the JDBC-ODBC Bridge?<br \/>\nAnswer:<br \/>\nYes, the JDK 1.1 and the Java 2 SDK, Standard Edition (formerly known as the JDK 1.2), contain both the JDBC API and the JDBC-ODBC Bridge. The Java 2 SDK, Standard Edition, contains the JDBC 2.0 core API, which is the latest version. It does not include the JDBC 2.0 Optional Package, which is part of the Java 2 SDK, Enterprise Edition, or which you can download separately.<br \/>\nNote that the version of the JDBC API and the JDBC-ODBC Bridge provided for separate download on the JDBC download page are only for use with the JDK 1.0.2.<\/p>\n<p>Question 89.<br \/>\nAre there any ODBC drivers that do not work with the JDBC-ODBC Bridge?<br \/>\nAnswer:<br \/>\nMost ODBC 2.0 drivers should work with the Bridge. Since there is some variation in functionality between ODBC drivers, the functionality of the bridge may be affected. The bridge works with popular PC databases, such as Microsoft Access and FoxPro.<\/p>\n<p>Question 90.<br \/>\nDoes the JDBC-ODBC Bridge work with Microsoft J++?<br \/>\nAnswer:<br \/>\nNo, J++ does not support the JDBC-ODBC bridge since it doesn\u2019t implement the Java Native Interface (JNI). Any all-Java JDBC driver should work with J++, however.<\/p>\n<p>Question 91.<br \/>\nWhat causes the \u201cNo suitable driver\u201d error?<br \/>\nAnswer:<br \/>\n\u201cNo suitable driver\u201d is an error that usually occurs during a call to the DriverManager.getConnection method. The cause can be failing to load the appropriate JDBC drivers before calling the getConnection method, or it can be specifying an invalid JDBC URL\u2014one that isn\u2019t recognized by your JDBC driver. Your best bet is to check the documentation for your JDBC driver or contact your JDBC driver vendor if you suspect that the URL you are specifying is not being recognized by your JDBC driver.<\/p>\n<p>In addition, when you are using the JDBC-ODBC Bridge, this error can occur if one or more of the shared libraries needed by the Bridge cannot be loaded. If you think this is the cause, check your configuration to be sure that the shared libraries are accessible to the Bridge.<\/p>\n<p>Question 92.<br \/>\nWhy isn\u2019t the java.sql.DriverManager class being found?<br \/>\nAnswer:<br \/>\nThis problem can be caused by running a JDBC applet in a browser that supports the JDK 1.0.2, such as Netscape Navigator 3.0. The JDK 1.0.2 does not contain the JDBC API, so the DriverManager class typically isn\u2019t found by the Java virtual machine running in the browser.<br \/>\nHere\u2019s a solution that doesn\u2019t require any additional configuration of your web clients. Remember that classes in java.* packages cannot be downloaded by most browsers for security reasons. Because of this, many vendors of all-Java JDBC drivers supply versions of the java.sql.* classes that have been renamed to jdbc. sql.*, along with a version of their driver that uses these modified classes.<\/p>\n<p>If you import jdbc.sql.* in your applet code instead of java.sql.*, and add the jdbc.sql.* classes provided by your JDBC driver vendor to your applet\u2019s codebase, then all of the JDBC classes needed by the applet can be downloaded by the browser at run time, including the DriverManager class.<\/p>\n<p>This solution will allow your applet to work in any client browser that supports the JDK 1.0.2. Your applet will also work in browsers that support JDK 1.1, although you may want to switch to the JDK 1.1 classes for performance reasons. Also, keep in mind that the solution outlined here is just an example and that other solutions are possible.<\/p>\n<p>Question 93.<br \/>\nWhy doesn\u2019t calling the method Class.forName load my JDBC driver?<br \/>\nAnswer:<br \/>\nThere is a bug in the JDK 1.1.x that can cause the method Class.forName to fail. A workaround is to explicitly call the method DriverManager.register driver(new YourDriverClassO). The exact problem in the JDK is a race condition in the class loader that prevents the static section of code in the driver class from executing and registering the driver with the DriverManager.<\/p>\n<p>Question 94.<br \/>\nWhy do the java.sql and java. math packages fail to download java.* packages? Is there a workaround?<br \/>\nAnswer:<br \/>\nFor security reasons, browsers will not download java.* packages. In order to use the JDBC API with browsers that have not been upgraded to JDK1.1 or beyond, we recommend that the java.sql and java. math packages are renamed jdbc. sql amkjdbc.math. Most vendors supplying JDBC technology-enabled drivers that are written purely in the Java programming language already provide versions of these renamed packages. When JDK 1.1 support has been added to your browser, you should convert your applets back to java.* package names.<\/p>\n<p>Question 95.<br \/>\nWhy is the precision of java. math.BigDecimal limited to 18 digits in the JDK 1.0.2 add-on version of the JDBC API?<br \/>\nAnswer:<br \/>\nIn JDK 1.1, java. math.BigInteger is implemented in C. It supports a precision of thousands of digits. The same is true for BigDecigmal.<br \/>\nThe version of Biglnteger provided with the JDK 1.0.2 add-on version of the JDBC API is a simplified version written in the Java programming language, and it is limited to 18 digits. Because the implementation of BigDecimal is based on Biglnteger, it also is limited to this precision.<br \/>\nIn the JDBC 2.0 API, you can use a new version of the method ResultSet.getBigDecimal that does not take a scale parameter and returns a BigDecimal with full precision.<\/p>\n<p>Question 96.<br \/>\nCan the JDBC API be added to JDK 1.0.2?<br \/>\nAnswer:<br \/>\nYes. Download the JDBC 1.22 API from the JDBC download page and follow the installation instructions in the release notes. If you are using any version of the JDK from 1.1 on, the JDBC API is already included, and you should not download the JDBC 1.22 API.<\/p>\n<p>Question 97.<br \/>\nHow do I retrieve a whole row of data at once, instead of calling an individual ResultSet?getXXX method for each column?<br \/>\nAnswer:<br \/>\nThe ResultSet.getXXX methods are the only way to retrieve data from a ResultSet object, which means that you have to make a method call for each column of a row. It is unlikely that this is the cause of a performance problem, however, because it is difficult to see how a column could be fetched without at least the cost of a function call in any scenario. We welcome input from developers on this issue.<\/p>\n<p>Question 98.<br \/>\nWhy does the ODBC driver manager return \u2018Data source name not found and no default driver specified Vendor: O\u2019<br \/>\nAnswer:<br \/>\nThis type of error occurs during an attempt to connect to a database with the bridge. First, note that the error is coming from the ODBC driver manager.<br \/>\nThis indicates that the bridge-which is a normal ODBC client-has successfully called ODBC, so the problem isn\u2019t due to native libraries not being present. In this case, it appears that the error is due to the fact that an ODBC DSN (data source name) needs to be configured on the<br \/>\nclient machine. Developers often forget to do this, thinking that the bridge will magically find the DSN they configured on their remote server machine.<\/p>\n<p>Question 99.<br \/>\nAre all the required JDBC drivers to establish connectivity to my database part of the JDK?<br \/>\nAnswer:<br \/>\nNo. There aren\u2019t any JDBC technology-enabled drivers bundled with the JDK 1.1.x or Java 2 Platform releases other than the JDBC-ODBC Bridge. So, developers need to get a driver and install it before they can connect to a database. We are considering bundling JDBC technology-enabled drivers in the future.<\/p>\n<p>Question 100.<br \/>\nIs the JDBC-ODBC Bridge multi-threaded?<br \/>\nAnswer:<br \/>\nNo. The JDBC-ODBC Bridge does not support concurrent access from different threads. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded Java programs may use the Bridge, but they won\u2019t get the advantages of multi-threading. In addition, deadlocks can occur between locks held in the database and the semaphore used by the Bridge. We are thinking about removing the synchronized methods in the future. They were added originally to make things simple for folks writing Java programs that use a single-threaded ODBC driver.<\/p>\n<p>Question 101.<br \/>\nDoes the JDBC-ODBC Bridge support multiple concurrent open statements per connection?<br \/>\nAnswer:<br \/>\nNo. You can open only one Statement object per connection when you are using the JDBC-ODBC Bridge.<\/p>\n<p>Question 102.<br \/>\nDoes the JDBC-ODBC Bridge developed by Morant and Sun support result sets that contain Japanese Characters (DBCS)?<br \/>\nAnswer:<br \/>\nYes, but we haven\u2019t tested this ourselves. The version of the Bridge in the Java 2 SDK, Standard Edition, and Java 2 SDK, Enterprise Edition, also supports a new charSet Connection property for specifying the character encoding used by the underlying DBMS.<\/p>\n<p>Question 103.<br \/>\nWhy can\u2019t I invoke the ResultSet methods after last and beforeFirst when the method next works?<br \/>\nAnswer:<br \/>\nYou are probably using a driver implemented for the JDBC 1.0 API. You need to upgrade to a JDBC 2.0 driver that implements scrollable result sets. Also, be sure that your code has created scrollable result sets and that the DBMS you are using supports them.<\/p>\n<p>Question 104.<br \/>\nHow can I retrieve a String or other object type without creating a new object each time?<br \/>\nAnswer:<br \/>\nCreating and garbage collecting potentially large numbers of objects (millions) unnecessarily can really hurt performance. It may be better to provide a way to retrieve data like strings using the JDBC API without always allocating a new object.<br \/>\nWe are studying this issue to see if it is an area in which the JDBC API should be improved. Stay tuned, and please send us any comments you have on this question.<\/p>\n<p>Question 105.<br \/>\nThere is a method to get column count in the JDBC API. Is there a similar method to find the number of rows in a result set?<br \/>\nAnswer:<br \/>\nNo, but it is easy to find the number of rows. If you are using a scrollable result set, rs, you can call the methods rs. last and then rs.grow to find out how many rows rs has. If the result is not scrollable, you can either count the rows by iterating through the result set or get the number of rows by submitting a query with a COUNT column in the SELECT clause.<\/p>\n<p>Question 106.<br \/>\nI would like to download the JDBC-ODBC Bridge for the Java 2 SDK, Standard Edition (formerly JDK 1.2). I\u2019m a beginner with the JDBC API, and I would like to start with the Bridge. How do I do it?<br \/>\nAnswer:<br \/>\nThe JDBC-ODBC Bridge is bundled with the Java 2 SDK, Standard Edition, so there is no need to download it separately.<\/p>\n<p>Question 107.<br \/>\nIf I use the JDBC API, do I have to use ODBC underneath?<br \/>\nAnswer:<br \/>\nNo, this is just one of many possible solutions. We recommend using a pure Java JDBC technology-enabled driver, type 3 or 4, in order to get all of the benefits of the Java programming language and the JDBC API.<\/p>\n<p>Question 108.<br \/>\nOnce I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?<br \/>\nAnswer:<br \/>\nYou still need to get and install a JDBC technology-enabled driver that supports the database that you are using. There are many drivers available from a variety of sources. You can also try using the JDBC-ODBC Bridge if you have ODBC connectivity set lip already. The Bridge comes with the Java 2 SDK, Standard Edition, and Enterprise Edition, and it doesn\u2019t require any extra setup itself. The Bridge is a normal ODBC client. Note, however, that you should use the JDBC- ODBC Bridge only for experimental prototyping or when you have no other driver available.<\/p>\n<p>Question 109.<br \/>\nWhat is a JDBC Driver?<br \/>\nAnswer:<br \/>\nA JDBC driver is the set of classes that implement the JDBC interfaces for a particular database.<br \/>\nThere are four different types of JDBC drivers:<br \/>\nA Type 1 driver is a JDBC-ODBC bridge driver; this type of driver enables a client to connect to an ODBC database via Java calls and JDBC\u2014neither the database nor middle tier needs to be Java compliant. However, ODBC binary code must be installed on each client machine that uses this driver.<\/p>\n<p>A Type 2 driver converts JDBC calls into calls for a specific database. This driver is referred to as a native-API, partly Java driver. As with the Type 1 driver, some binary code may be required on the client machine, which means this type of driver is not suitable for downloading over a network to a client.<br \/>\nA Type 3 driver is a JDBC-Net pure Java driver, which translates JDBC calls into a database-independent net protocol. Vendors of database middleware products can implement this type of driver into their products to provide interoperability with the greatest number of database servers.<\/p>\n<p>Finally, a Type 4 driver, or, native protocol, pure Java driver converts JDBC calls into the network protocol used by the database directly. A Type 4 driver requires no client software<\/p>\n<p>so it\u2019s ideal for deployment to browsers at runtime. Each of these driver types has its own optimal usage scenarios and will affect the way you deploy a given Java application.<br \/>\nFor example, because Type 4 drivers are 100% Java, use Java sockets to connect to the database, and require no client-side data access code, they are ideal for applets or other download situations inside a firewall.<\/p>\n<p>Question 110.<br \/>\nWhat are the Oracle\u2019s JDBC Drivers?<br \/>\nAnswer:<br \/>\nOracle provides both Type 2 and Type 4 drivers. All Oracle JDBC drivers support the full JDBC specification, but in addition, they support the extended capabilities of the Oracle database. For example, the JDBC specification doesn\u2019t support LOB data, but the Oracle OCI8 JDBC driver does. Oracle\u2019s implementation of the Type 2 JDBC driver is referred to as the Oracle \u201cOCI driver,\u201d and the version of this driver that supports an Oracle 7 database is the OCI7 driver and the OCI8 supports Oracle 8.<\/p>\n<p>These drivers are platform-specific; for example, the Windows NT and Windows 95 version of the driver (oci805jdbc.dll.) is implemented as a dynamic link library (DLL) in C. As mentioned previously, Type 2 drivers may require client code. In the case of the OCI8 driver, the clients must have Oracle\u2019s Net*8 and all other dependent files loaded.<\/p>\n<p>A common way to implement Oracle OCI drivers is to use Oracle Application Server with the JWeb cartridge on the middle tier and deploy the client presentation logic as an applet; the interaction with the Oracle database is conducted from the middle tier only, with just the results sent to the client applet as pure HTML or Java and HTML.<\/p>\n<p>All Oracle drivers are compliant with the Java Development Kit JDK 1.0 and 1.1.x and support the JDBC 1.22 standard. In addition, all Oracle JDBC drivers support data types such as RAW and LONG RAW, ROWID, and RECURSOR, which are supported in Oracle databases but not part of the JDBC standard. Oracle\u2019s drivers also support execution of PL\/SQL stored procedures and anonymous blocks (for dynamic execution), and include capabilities such as row pre-fetching, execution batching, and defining query columns to reduce the network round trips to the Oracle database.<\/p>\n<p>In addition, the OCI driver for Oracle8 supports oracle data types CLOB, BLOB, NCLOB, and BFILE. The screenshot shows an example of one of the classes in the Oracle JDBC, as part of the class hierarchy from which it descends, as displayed in Oracle\u2019s JDeveloper integrated development environment. As you can see, the OraclePreparedStatement class inherits from the java.sql.PreparedStatement class, which in turn inherits from the java.sql.Statement.<\/p>\n<p>Oracle also provides a Type 4 JDBC driver, referred to as the Oracle \u201cthin\u201d driver. This driver includes its own implementation of a TCP\/IP version of Oracle\u2019s Net8 written entirely in Java, so it is platform-independent, can be downloaded to a browser at runtime, and does not require any Oracle software on the client-side. This driver requires a TCP\/IP listener on the server-side, and the client connection string uses the TCP\/IP port address, not the TNSNAMES entry for the database name.<\/p>\n<p>1. Add JDBC classes to your Java application or applet class by adding the following statement to your Java source code:<br \/>\nimport java.sql.*;<br \/>\nTo use the extended capabilities of the Oracle database, you must also import the Oracle JDBC driver. The statement in Java source looks like this: import oracle.JDBC.driver.*<\/p>\n<p>2. Load the JDBC driver by including the following statement in your class. Class.forName(\u201coracle.JDBC.driver.OracleDriver\u201d);<br \/>\nYou can load the driver from your class-initialization routine.<\/p>\n<p>3. Obtain a connection to an Oracle database by calling the getConnectionO method of the JDBC DriverManager class. When you call this method you need to specify the connection information for the database in the form of a URL. The form the URL will take depends on the driver used. For example, to use the pure Java Type 4 Oracle driver (the thin driver) to connect to an Oracle7 database, the URL would read: jdbc:oracle:thin@database_name:port_no:SID<br \/>\nTo connect to an Oracle8 database using the OCI driver, the URL would be<br \/>\nmore like: &#8216;<br \/>\njdbc:oracle:oci8@database_name<br \/>\nTo specify the database for use with an OCI driver, you can use either a SQL*Net name-value pair or, if you\u2019re using an Oracle Name server, you can use the name from the DNS name. ora file. (Both of these strings would conclude with the login information as well\u2014specifically the user name and password\u2014 but we\u2019ve eliminated that from this example.)<br \/>\nThe preliminary driver and database-connection issues are now taken care of, there are still several other things your Java source code must include in order<br \/>\nfor the compiled code to submit queries to the database and process results.<br \/>\n4. Create a Statement object by calling the create statement( ) method of the Connection object you created in the previous step. The following statement creates a Statement object stmt:<br \/>\nStatement stmt = conn.createStatement 0;<br \/>\n5. Once the Statement object exists (in code), the application can then include code to execute a SQL query by calling the executeQuery( ) method of the Statement object.The execute query( ) method returns the result of the query in the ResultSet object. The following statement executes a query: ResultSet rset = stmt.executeQuery (SELECT name from emp where empno = 7900);<br \/>\n6. Finally, call the next( ) method of a ResultObject to retrieve a row and display it. Use a loop if the query returns more then one row from the database. For example, the following statements get the name of an employee from the ResultSet object and display it in java.awt text control placed on the GUI. rset.next( );<br \/>\nenameTxtb.setText = ((String)rset.getString(l));<\/p>\n<p>Question 111.<br \/>\nWhat is Annotation in Java?<br \/>\nAnswer:<br \/>\nAn annotation, in the java programming language, is a special form of syntactic metadata that can be added to Java Source Code.<br \/>\nClasses, methods, variables parameters, and packages may be annotated.<br \/>\nUnlike Java doc tags, Java annotations are reflective, in that they are embedded in class files generated by the compiler and may be retained by the Java VM to make them retrievable at run-time. Annotation is basically to attach metadata to a method, class, or package. Metadata is used by the compiler to perform some basic compile-time checking.<\/p>\n<p>Question 112.<br \/>\nWhat is the difference between PreparedStatement and Statement in java? Answer:<\/p>\n<ul>\n<li>A statement is parsed and executed each time its call is sent to the database.<\/li>\n<li>A prepared statement may be parsed once and executed repeatedly with different parameters.<\/li>\n<\/ul>\n<p>There are four steps for the execution of the query:<\/p>\n<ol>\n<li>Query is parsed<\/li>\n<li>The query is compiled.<\/li>\n<li>The query is optimized.<\/li>\n<li>The query is executed.<\/li>\n<\/ol>\n<p>In the case of the statement, the above four steps are performed every time. And in the case of a prepared statement, the above three steps are performed once.<\/p>\n<p>Question 113.<br \/>\nWhat is CallableStatement? How you can call the stored procedure to pass IN parameter?<br \/>\nAnswer:<br \/>\n<a href=\"https:\/\/btechgeeks.com\/callablestatement-in-java\/\">CallableStatement in java<\/a> is used for calling database stored procedures. Example: Adding Employee details in DB whenever a new Employee is joining. Employee Information: Employee Id, Name, and joining Date.<br \/>\nCode:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">package com.mytest.jdbc;\r\nimport java.sql.CallableStatement;\r\nimport java.sql.DriverManager; import java.sql.connection;\r\nimport j ava.sql.SQLException;\r\npublic class AddEmployeeExample {\r\nprivate static final string DB_DRIVER = \u201coracle.jdbc.driver.\r\nOracleDriver\u201d;\r\nprivate static final string DB_CONNECTXON = \u201cjdbc:oracle:thin:@\r\n1ocalhost:1521:MYTEST\u201d;\r\nprivate static final String DB_USER = \u201cmy_user\u201d;\r\nprivate static final string DB_PASSWORD = \"my_password\u201d;\r\npublic static void main(string[ ] argv) {\r\ntry\r\n{\r\naddEmployeelnfo( );\r\n}-catch (SQLExcepti on e) {\r\nsystem.out.println(e.getMessage ( ));\r\n}\r\n}\r\nprivate static void addEmployeelnfo( ) throws SQLException {\r\nConnection dbconnection = null;\r\nCallableStatement CallableStatement = null;\r\nstring insertEmployeeStoreProc = \u201c{call insertEmployeeC?,?,?)}\u201d; try {\r\ndbconnection = getOBConnection( );\r\nCallableStatement = dbconnection.preparecall(insertEmployeeStoreProc);\r\ncallablestatement.setlnt(l, 377602);\r\nCallableStatement.setstring(2, \u201cNishant Singh\u201d);\r\ncallableStatement.setDate(3, getcurrentDate( ));\r\n\/\/ execute insert store procedure\r\ncal1ablestatement.executeupdate( );\r\n} catch (SQLException exp) {\r\nSystem.out.println(exp.getMessage( ));\r\n} finally {\r\nif (callablestatement != null) {\r\ncal 1ablestatement.close( );\r\n}\r\nif (dbconnection != null) {\r\ndbconnection.close( );\r\n}\r\n}\r\n}\r\nprivate static connection getDBConnection( ) {\r\nConnection dbconnection = null;\r\ntry {\r\nclass.forName(DB_DRIVER);\r\n} catch (classNotFoundException e) {\r\nSystem.out.println(e.getMessage ( ));\r\n}\r\ntry {\r\ndbconnection = DriverManager.getConnectionC DB_CONNECTION, DB_USER,DB_ PASSWORD);\r\nreturn dbconnection;\r\n} catch (SQLException e) {\r\nSystem.out.println(e.getMessage( ));\r\n}\r\nreturn dbconnection;\r\n}\r\nprivate static java.sql.Date getCurrentDate( ) {\r\njava.util.Date today = new java.util.Date( );\r\nreturn new java.sql.Date(today.getTime( ));\r\n}\r\n}\r\n<\/pre>\n<p>Question 114.<br \/>\nUsing Callable Statement how can you pass OUT Parameters, explain with example? \u2022<br \/>\nAnswer:<br \/>\nTake the example of Employee, where you want the details of Employee by Id.<br \/>\n<strong>Code:<\/strong> Use the same code structure get DB Connection etc.<\/p>\n<pre>\/\/getDBUSERByUserid is a stored procedure\r\nString getEmplnfoByEmpldSql = \u201c{call getEmplnfoByEmpld(?,?,?,?)}\u201d; \r\ncal1ablestatement = dbconnection.prepareCal1(getEmplnfoByEmpldSql);\r\n callablestatement.setlnt(l, 377602);\r\ncallableStatement.register0utParameter(2, java.sql.Types.VARCHAR);\r\ncallablestatement.registeroutParameter(B, java.sql.Types.DATE);\r\nexecute getEmplnfoByEmpld store procedure\r\ncal 1 abl eStatement. executeltpdate ( );\r\nstring empName = cal1ableStatement.getstring(2);\r\nstring joiningDate = callab!eStatement.getDate(3);<\/pre>\n<p>Question 115.<br \/>\nHow can you determine the SGA site?<br \/>\nAnswer:<br \/>\nDatabase &#8211; JDBC (java.sql)<br \/>\n<strong>Connecting to a Database<\/strong><br \/>\nThis example uses the JDBC-ODBC bridge to connect to a database called \u201cmy database\u201d.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">try {\r\nclass.forName(\u201csun.j dbc.odbc.JdbcodbcDriver\u201d);\r\nString url = \u201cjdbc:odbc:mydatabase\u201d;\r\nConnection con = DriverManager.getConnection(url, \u201clogin\u201d, \u201cpassword\u201d);\r\n} catch (classNotFoundException e) {\r\n} catch (SQLException e) {\r\n}<\/pre>\n<p><strong>Creating a Table<\/strong><br \/>\nThis example creates a table called \u201ctable\u201d with three columns: COL_A which holds strings, COL_B which holds integers, and COL_C which holds floating-point numbers.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">try {\r\nStatement stmt = con.createStatement( );\r\nstmt.execute update(\u201cCREATE TABLE mytable (COL^A VARCHAR(100), COL_B\r\nINTEGER, COI C FLOAT)\u201d);\r\n} catch (SQLException e) {\r\n}<\/pre>\n<p><strong>Entering a New Row into a Table<\/strong><br \/>\nThis example enters a row containing a string, an integer, and a floating-point number into the table called \u201ctable\u201d.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">try {\r\nStatement stmt = connection.createStatement( );\r\nstmt.executeupdate(\u201ciNSERT INTO mytable VALUES (\u2018Patrick chan\u2019, 12B, 1.23)\u201d);\r\nconnection.close( );\r\n} catch (SQLException e) {\r\n}<\/pre>\n<p><strong>Getting All Rows from a Table<\/strong><br \/>\nThis example retrieves all the rows from a table called \u201ctable\u201d. A row in \u201cmytable\u201d consists of a string, integer, and floating-point number.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">try {\r\nstatement stmt = connection.createstatement( );\r\n\/\/ Get data using colunm names.\r\nResultSet rs = stmt.executeQuery(\u201cSELECT * FROM mytable\u201d);\r\nwhile (rs.next( )) {\r\nstring s = rs.getstring(\u201cC0L_JA\u201d);\r\nint i = rs.getlnt(\u201cCOL_B\u201d);\r\nfloat f = rs.getFloat(\u201cCOL_C\u201d);\r\nprocesses, i, f);\r\n}<\/pre>\n<p><strong>Get data using column numbers.<\/strong><\/p>\n<pre>\\rs = stmt.executeQuery(\u201cSELECT * FROM mytable\");\r\nwhile (rs.nextO) {\r\nstring s = rs.getString(l);\r\nint i = rs.getlnt(2);\r\nfloat f = rs.getFloat(3);\r\nprocess(s, i, f);\r\n}<\/pre>\n<p><strong>Getting Particular Rows from a Table<\/strong><br \/>\nThis example retrieves all rows from a table called \u201cmytable\u201d whose column COL_A equals \u201cPatrick Chan\u201d. A row in \u201cmytable\u201d consists of a string, integer, and floating-point number.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">try {\r\nStatement stmt = connection.createstatement( );\r\nResultSet rs = stmt.executeQuery(\u201cSELECT * FROM mytable WHERE COL_A = \u2018Patrick chan\u201d\u2019);\r\nrs.next( );\r\nString s = rs.getString(\u201cC0L_A\u201d);\r\nint i = rs.getlnt(\u201cCOL_B\u201d);\r\nfloat f = rs.getFloat(\u201ccoL_c\u201d);\r\nprocess (s, i, f) ;\r\n} catch (SQLException e) {\r\n}<\/pre>\n<p><strong>Updating a Row of Data in a Table<\/strong><br \/>\nThis example updates a row in a table called \u201cmytable\u201d. In particular, for all rows whose column COL_B equals 123, column COL_A is set to \u201cJohn Doe\u201d.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">try {\r\nStatement stmt = connection.createstatementO;\r\nint numupdated = stmt.executeUpdate(\u201cuPDATE mytable SET COi\u2014A = \u2018John\r\nDoe\u2019 WHERE COi B = 123\u201d);\r\nconnection, close( );\r\n} catch (SQLException e) {\r\n}<\/pre>\n<p><strong>Using a Prepared Statement<\/strong><\/p>\n<p>A prepared statement should be used in cases where a particular SQL statement is used frequently. The prepared statement is more expensive to set up but executes faster than a statement. This example demonstrates a prepared statement for getting all rows from a table called \u201ctable\u201d whose column COL_A equals \u201cPatrick Chan\u201d. This example also demonstrates a prepared statement for updating data in the table. In particular, for all rows whose column COL_B equals 123, column COL_A is set to \u201cJohn Doe\u201d.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">try {\r\n\/\/ Retrieving rows from the database.\r\nPreparedStatement stmt = connection.preparestatement(\u201cSELECT * FROM mytable WHERE COL_A = ?\u201d);\r\nint colunm = 1;\r\nstmt.setStringCcolunm, \u201cPatrick Chan\u201d);\r\nResultSet rs = stmt.executeQuery( );\r\n\/\/ updating the database.\r\nstmt = connection.prepareStatement(\u201cUPDATE mytable SET coi A = ? WHERE\r\nCOI_B = ?\");\r\ncolunm = 1;\r\nstmt.setStringCcolunm, \u201cjohn Doe\u201d);\r\ncolunm = 2;\r\nstmt.setlnt(colunm, 123);\r\nint numupdated = stmt.executeupdate( );\r\n} catch (SQLException e) {\r\n}<\/pre>\n<p>Question 116.<br \/>\nHow to Interact with DB?<br \/>\nAnswer:<br \/>\nGenerally, every DB vendor provides a User Interface through which we can easily execute SQL queries and gets the result (For example Oracle Query Manager for Oracle, and TOAD (www.quest.com) tool common to all the databases). And these tools will help DB developers to create databases. But as a programmer we want to interact with the DB dynamically to execute some SQL queries from our application (Any application like C, C++, JAVA, etc), and for this requirement, DB vendors provide some Native Libraries (Vendor Specific) using this we can interact with the DB i.e. If you want to execute some queries on Oracle DB, oracle vendor provides an OCI (Oracle Call Interface) Libraries to perform the same.<\/p>\n<p>Question 117.<br \/>\nWhat is ODBC?<br \/>\nAnswer:<br \/>\nODBC (Open Database Connectivity) is an ISV (Independent software vendor product) composes of native API to connect to different databases via a single API called ODBC.<br \/>\nOpen Database Connectivity (ODBC) is an SQL-oriented application programming interface developed in collaboration with IBM and some other database vendors. ODBC comes with Microsoft products and with all databases on Windows OS.<br \/>\n<strong>ODBC Architecture<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-15268\" src=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-5.png\" alt=\"Java Database Connectivity (JDBC) Interview Questions in Java chapter 14 img 5\" width=\"563\" height=\"332\" srcset=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-5.png 563w, https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-5-300x177.png 300w\" sizes=\"(max-width: 563px) 100vw, 563px\" \/><\/p>\n<p><strong>Advantages<\/strong><\/p>\n<ul>\n<li>Single API (Protocol) is used to interact with any DB<\/li>\n<li>Switching from one DB to another is easy<\/li>\n<li>Doesn\u2019t require any modifications in the Application when you want to shift from one DB to other<\/li>\n<\/ul>\n<p>Question 118.<br \/>\nHow to Make Updates to Updatable Result Sets?<br \/>\nAnswer:<br \/>\nAnother new feature in the JDBC 2.0 API is the ability to update rows in a result set using methods in the Java programming language rather than having to send an SQL command. But before you can take advantage of this capability, you need to create a ResultSet object that is updatable. In order to do this, you supply the ResultSet constant CONCUR_UPDATABLE to the createStatement method.<br \/>\n<strong>E.g.<\/strong><br \/>\nConnection con = DriverManager.getConnection(\u201cjdbc:mySubprotocol:mySubNa me\u201d);<br \/>\nStatement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCURJLJPDATABLE);<br \/>\nResultSet uprs = (\u201cSELECT COF_NAME, PRICE FROM COFFEES\u201d);<\/p>\n<p>Question 119.<br \/>\nWhat is ACID?<br \/>\nAnswer:<br \/>\n<strong>ACID<\/strong> is related to transactions. It is an acronym for Atomic, Consistent, Isolation, and Durable. The transaction must be following the above four properties to be a better one.<\/p>\n<p><strong>Atomic:<\/strong> It means a transaction must execute all or nothing at all.<\/p>\n<p><strong>Consistent:<\/strong> Consistency is a transactional characteristic that must be enforced by both the transactional system and the application developer<br \/>\nIsolation: Transaction must be allowed to run itself without the interference of the other processor transactions.<\/p>\n<p><strong>Durable:<\/strong> Durability means that all the data changes made by the transaction must be written in some type of physical storage before the transaction is successfully completed. This ensures that transactions are not lost even if the system crashes.<\/p>\n<p>Question 120.<br \/>\nHow JDBC API does help us in achieving loose coupling between Java Program and JDBC Drivers API?<br \/>\nAnswer:<br \/>\nJDBC API uses Java Reflection API to achieve loose coupling between java programs and JDBC Drivers. If you look at a simple JDBC example, you will notice that all the programming is done in terms of JDBC API and Driver comes into the picture only when it\u2019s loaded through reflection using the Class.forName( ) method.<\/p>\n<p>I think this is one of the best examples of using Reflection in core java classes to make sure that our application doesn\u2019t work directly with Drivers API and that makes it very easy to move from one database to another. Please read more at JDBC Example.<\/p>\n<p>Question 121.<br \/>\nWhat is JDBC Connection? Explain steps to get a Database connection in a simple java program.<br \/>\nAnswer:<br \/>\nJDBC Connection is like a Session created with the database server. You can also think Connection is like a Socket connection from the database server.<br \/>\nCreating a JDBC Connection is very easy and requires two steps:<\/p>\n<ol>\n<li>Register and Load the Driver: Using Class.forName( ), the Driver class is registered to the DriverManager and loaded in the memory.<\/li>\n<li>Use DriverManager to get the Connection object: We get connection object fromDriverManager.getConnection( ) by passing Database URL String, username and password as argument.<\/li>\n<\/ol>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">connection con = null;\r\ntry{\r\n\/\/ load the Driver class\r\nClass.forName(\u201ccom.mysql.jdbc.Driver\u201d);\r\n\/\/ create -the connection now\r\ncon = DriverManager.getconnection(\u201cjdbc:mysql:\/\/local host:3306\/ userDB\u201d,\u2019\u2019pankaj\u201d, \u201cpankajl23\u201d);\r\n}catch (SQLException e) {\r\nSystem.out.println(\u201ccheck database is UP and configs are correct\u201d);\r\ne.printStackTrace( );\r\n}catch (classNotFoundException e) {\r\nSystem.out.println(\u201cPiease include 3DBC MySQL jar in classpath\u201d);\r\ne.printStackTrace( );\r\n}<\/pre>\n<p>Question 122.<br \/>\nWhat is the use of the JDBC DriverManager class?<br \/>\nAnswer:<br \/>\nJDBC DriverManager is the factory class through which we get the Database Connection object. When we load the JDBC Driver class, it registers itself to the DriverManager, you can look up the JDBC Driver classes source code to check this.<br \/>\nThen when we call DriverManager.get a connection( ) method by passing the database configuration details, DriverManager uses the registered drivers to get the Connection and return it to the caller program.<\/p>\n<p>Question 123.<br \/>\nHow to get the Database server details in the java program?<br \/>\nAnswer:<br \/>\nWe can use the DatabaseMetaData object to get the database server details. When the database connection is created successfully, we can get the metadata object by calling the get metadata( ) method. There are so many methods in DatabaseMetaData that we can use to get the database product name, its version, and configuration details.<\/p>\n<p>DatabaseMetaData metaData = con.getMetaData( );<br \/>\nString dbProduct = metaData.getDatabaseProductName( );<\/p>\n<p>Question 124.<br \/>\nWhat is JDBC Statement?<br \/>\nAnswer:<br \/>\nJDBC API Statement is used to execute SQL queries in the database. We can create the Statement object by calling Connection to get statements( ) method. We can use Statement to execute static SQL queries by passing query through different execute methods such as execute( ), execute query( ), execute update( ) etc.<\/p>\n<p>Since the query is generated in the java program, if the user input is not properly validated it can lead to an SQL injection issue, more details can be found in SQL Injection Example.<\/p>\n<p>By default, only one ResultSet object per Statement object can be open at the same time. Therefore, if we want to work with multiple ResultSet objects, then each must have been generated by different Statement objects. All execute( ) methods in the Statement interface implicitly close a statement&#8217;s current ResultSet object if an open one exists.<\/p>\n<p>Question 125.<br \/>\nWhat is the difference between execute, executeQuery, executeUpdate?<br \/>\nAnswer:<br \/>\nStatement execute(String query) is used to execute an SQL query and it returns TRUE if the result is a ResultSet such as running Select queries. The output is FALSE when there is no ResultSet object such as running Insert or Update queries. We can use getResultSet( ) to get the ResultSet and getUpdateCountO method to retrieve the update count.<\/p>\n<p>Statement executeQuery(String query) is used to execute Select queries and returns the ResultSet. ResultSet returned is never null even if there are no records matching the query. When executing select queries we should use the executeQuery method so that if someone tries to execute an insert\/update statement it will throw java.sql. SQLException with message \u201cexecuteQuery method can not be used for update\u201d. Statement executeUpdate(String query) is used to execute Insert\/Update\/Delete (DML) statements or DDL statements that returns nothing. The output is int and equals the row count for SQL Data Manipulation Language (DML) statements. For DDL statements, the output is 0.<\/p>\n<p>You should use execute( ) method only when you are not sure about the type of statement else use the executeQuery or executeUpdate method.<\/p>\n<p>Question 126.<br \/>\nWhat is JDBC PreparedStatement?<br \/>\nAnswer:<br \/>\nJDBC PreparedStatement object represents a precompiled SQL statement. We can use its setter method to set the variables for the query.<br \/>\nSince PreparedStatement is precompiled, it can then be used to efficiently execute this statement multiple times. PreparedStatement is a better choice than Statement because it automatically escapes the special characters and avoids SQL injection attacks.<\/p>\n<p>Question 127.<br \/>\nHow to set NULL values in JDBC PreparedStatement?<br \/>\nAnswer:<br \/>\nWe can use the PreparedStatement setNullO method to bind the null variable to a parameter. The setNull method takes index and SQL Types as argument, for example<br \/>\nps.setNull(10, java.sql.Types.INTEGER);.<\/p>\n<p>Question 128.<br \/>\nWhat is the use of the getGeneratedKeys( ) method in the Statement?<br \/>\nAnswer:<br \/>\nSometimes a table can have auto-generated keys used to insert the unique column value for the primary key. We can use the Statement getGeneratedKeys( ) method to get the value of this auto-generated key.<\/p>\n<p>Question 129.<br \/>\nWhat causes No suitable driver error?<br \/>\nAnswer:<br \/>\n\u201cNo suitable driver\u201d occurs during a call to the DriverManager. getConnection method may be of any of the following reasons:<\/p>\n<ul>\n<li>Due to failing to load the appropriate JDBC drivers before calling the getConnection method.<\/li>\n<li>It can be specifying an invalid JDBC URL, one that is not recognized by the JDBC driver.<\/li>\n<li>This error can occur if one or more of the shared libraries needed by the bridge cannot be loaded<\/li>\n<\/ul>\n<p>Question 130.<br \/>\nWhat does setAutoCommit do?<br \/>\nAnswer:<br \/>\nsetAutoCommit( ) invokes the commit state query to the database. To perform batch updation we use the setAutoCommit( ) which enable us to execute more than one statement together, which in result minimize the database call and send all statement in one batch.<br \/>\nsetAutoCommit( ) allowed us to commit the transaction commit state manually the default values of the setAutoCommit( ) is true.<\/p>\n<p>Question 131.<br \/>\nWhy Prepared Statements are faster?<br \/>\nAnswer:<br \/>\nPrepared execution is faster than direct execution for statements executed more than three or four times because the statement is compiled only once. Prepared statements and JDBC drivers are linked with each other. We can bind drivers with columns by triggering the query into the database. When we execute Connection. prepareStatement( ), all the columns bindings take place, in order to reduce the time.<\/p>\n<p>Question 132.<br \/>\nHow can we store and retrieve images from the database?<br \/>\nAnswer:<br \/>\nBy using the PreparedStaement interface, we can store and retrieve images. Example to store the image in Oracle database:<br \/>\nYou can store images in the database in java with the help of the PreparedStatement interface.<br \/>\nThe setBinaryStream() method of PreparedStatement is used to set Binary information into the parameter index.<br \/>\nSignature of setBinaryStream method<br \/>\nThe syntax of setBinaryStream( ) method is given below:<\/p>\n<ol>\n<li>public void setBinaryStream(int paramlndexJnputStream stream) throws SQLException<\/li>\n<li>Public void set Binary Stream (int paramlndexJnputStream stream,long length)throws SQL Exception<\/li>\n<\/ol>\n<p>For storing images into the database, BLOB (Binary Large Object) data type is used in the table. For example:<\/p>\n<p>1. CREATE TABLE \u201cIMITABLE\u201d<br \/>\n2. (\u00abNAME\u00bb VARCHAR2(4000),<br \/>\n3. \u00abPHOTO\u00bb BLOB<br \/>\n4. )<br \/>\n5. \/<\/p>\n<p>Let\u2019s write the jdbc code to store the image in the database. Here we are using d:\\\\d. jpg for the location of image. You can change it according to the image location.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">import java.sql. ;\r\nimport java.io.*;\r\npublic class insertlmage {\r\npublic static void main(String[ ] args) {\r\ntry{\r\ncl ass.forName(\u201coracle.jdbc.driver.OracleDriver\u201d);\r\nconnection con=DriverManager.getConnection( \u201cjdbc:oracle:thin:@1ocalhos t:1521:xe\",\u2019\u2019system\u201d,\u2019\u2019oracle\u201d);\r\n\r\n\r\nPreparedStatement ps=con.prepareStatement(\u201cinsert into imgtable values(?,?)\u201d);\r\nps.setString(l,\u201dsonoo\u201d);\r\nFileinputStream fin=new FilelnputStream(\u00abd:\\\\g. jpg\u00bb);\r\nps. setBi naryStream,(2, fin, fin. avai 1 abl e( ));\r\nint i=ps.executeupdate();\r\nSystem.out.println(i+\u201d records affected\u201d);\r\ncon.clo se( );\r\n}catch (Exception e) {e.printStackTrace( );}\r\n}\r\n}\r\n<\/pre>\n<p>If you see the table, the record is stored in the database but the image will not be shown. To do so, you need to retrieve the image from the database which we are covering on the next page.<\/p>\n<p>Question 133.<br \/>\nDifferentiate between TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_ SENSITIVE.<br \/>\nAnswer:<\/p>\n<ul>\n<li>We will get a scrollable ResultSet object if we specify either one of the ResultSet constants.<\/li>\n<li>The difference between the two depends on, whether a resultset is showing fv changes or not.<\/li>\n<li>This difference depends on certain methods which are called to detect changes or not.<\/li>\n<li>The resultset TYPE_SCROLL_INSENSITI\\7E does not show the change to it but the ResultSet srs = TYPEJSCROLLJSENSITIVE will show the change.<\/li>\n<\/ul>\n<p>The following code explains the difference:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">statement stmt = con.createstatement (Resultset.TYPE_SCROLL_\r\nINSENSITIVE, ResultSet.CONCUR_READ_ONLY);\r\nResultset srs = stmt.executeQuery (\u201cSELECT COF_NAME, PRICE FROM COFFEES\u201d);\r\nsrs.afterLast( );\r\nwhile (srs.previous( ))\r\n{\r\nString name = srs.getString(\u201cC0F_NAME\u201d);\r\nfloat price 1= srs.getFloat(\u201cPRlCE\u201d);\r\nSystem.out.println(name + \u201c \u201c + pricel);\r\n}<\/pre>\n<p>Question 134.<br \/>\nName the new features added in JDBC 4.9<br \/>\nAnswer:<\/p>\n<ul>\n<li>Auto-loading by JDBC driver class.<\/li>\n<li>Enhanced Connection management.<\/li>\n<li>Rowland SQL enabled.<\/li>\n<li>DataSet is implemented by SQL by using Annotations.<\/li>\n<li>Enhancements of SQL exception handling<\/li>\n<li>Supporting SQL XML files.<\/li>\n<\/ul>\n<p>Question 135.<br \/>\nBriefly tell about the JDBC Architecture.<br \/>\nAnswer:<br \/>\nThe JDBC Architecture consists of two layers:<\/p>\n<ol>\n<li>The JDBC API<\/li>\n<li>The JDBC Driver API<\/li>\n<\/ol>\n<p>\u2666 The JDBC API provides the application-JDBC Manager connection.<br \/>\n\u2666 The JDBC Driver API supports the JDBC Manager-to-Driver Connection.<br \/>\n\u2666 The JDBC API interacts with a driver manager, a database-specific driver for providing transparent connectivity for the heterogeneous databases.<br \/>\n\u2666 The JDBC driver manager authenticates that the correct driver has been used to access each data source.<br \/>\n\u2666 The driver manager supports multiple concurrent drivers connected to multiple heterogeneous databases.<\/p>\n<p>Question 136.<br \/>\nDescribe how the JDBC application works.<br \/>\nAnswer:<br \/>\nA JDBC application may be divided into two layers:<\/p>\n<ul>\n<li>Driver layer<\/li>\n<li>Application layer<\/li>\n<li>The Driver layer consists of DriverManager class &amp; the JDBC drivers.<\/li>\n<li>The Application layer begins after putting a request to the DriverManager for the connection.<\/li>\n<li>An appropriate driver is chosen and used for establishing the connection.<\/li>\n<li>This connection is linked to the application layer.<\/li>\n<li>The application needs the connection for creating the Statement kind of objects by which the results are obtained.<\/li>\n<\/ul>\n<p>Question 137.<br \/>\nExplain how to Make Updates to the Updatable ResultSets.<br \/>\nAnswer:<\/p>\n<ul>\n<li>The JDBC 2.0 API can update rows in a ResultSet using the methods in Java rather than using a SQL command.<\/li>\n<li>But before doing that, we create a ResultSet object which is updatable.<\/li>\n<li>For doing this, w.e give the ResultSet CONCUR_UPDATABLE in the createStatement method.<\/li>\n<\/ul>\n<p><strong>Code:<\/strong><br \/>\nconnection con = DriverManager.getconnection(\u201cjdbc:mySubprotocol:mySubN ame\u201d);<br \/>\nstatement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);<br \/>\nResultSet uprs = stmt.executeQuery(\u201cSELECT COF_NAME, PRICE \u201c);<\/p>\n","protected":false},"excerpt":{"rendered":"<p>jdbc interview questions and answers for experienced: List of topic-wise frequently asked java interview questions with the best possible answers for job interviews. Java Database Connectivity (JDBC) Interview Questions in Java Question 1. What is JDBC? Answer: JDBC is a set of Java API for executing SQL statements. This API consists of a set of &#8230; <a title=\"jdbc interview questions and answers for experienced &#8211; Java Database Connectivity (JDBC) Interview Questions in Java\" class=\"read-more\" href=\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/\" aria-label=\"More on jdbc interview questions and answers for experienced &#8211; Java Database Connectivity (JDBC) Interview Questions in Java\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[17],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>jdbc interview questions and answers for experienced - Java Database Connectivity (JDBC) Interview Questions in Java - BTech Geeks<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"jdbc interview questions and answers for experienced - Java Database Connectivity (JDBC) Interview Questions in Java - BTech Geeks\" \/>\n<meta property=\"og:description\" content=\"jdbc interview questions and answers for experienced: List of topic-wise frequently asked java interview questions with the best possible answers for job interviews. Java Database Connectivity (JDBC) Interview Questions in Java Question 1. What is JDBC? Answer: JDBC is a set of Java API for executing SQL statements. This API consists of a set of ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/\" \/>\n<meta property=\"og:site_name\" content=\"BTech Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/btechgeeks\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-09T07:00:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-09T07:21:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:site\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prasanna\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"63 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/btechgeeks.com\/#organization\",\"name\":\"BTech Geeks\",\"url\":\"https:\/\/btechgeeks.com\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/btechgeeks\",\"https:\/\/www.instagram.com\/btechgeeks\/\",\"https:\/\/www.linkedin.com\/in\/btechgeeks\",\"https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg\",\"https:\/\/in.pinterest.com\/btechgeek\/\",\"https:\/\/twitter.com\/btech_geeks\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/btechgeeks.com\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"contentUrl\":\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"width\":350,\"height\":70,\"caption\":\"BTech Geeks\"},\"image\":{\"@id\":\"https:\/\/btechgeeks.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/btechgeeks.com\/#website\",\"url\":\"https:\/\/btechgeeks.com\/\",\"name\":\"BTech Geeks\",\"description\":\"Lecture Notes for BTech, BSc Students\",\"publisher\":{\"@id\":\"https:\/\/btechgeeks.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/btechgeeks.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png\",\"contentUrl\":\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png\",\"width\":539,\"height\":230,\"caption\":\"Java Database Connectivity (JDBC) Interview Questions in Java chapter 14 img 1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#webpage\",\"url\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/\",\"name\":\"jdbc interview questions and answers for experienced - Java Database Connectivity (JDBC) Interview Questions in Java - BTech Geeks\",\"isPartOf\":{\"@id\":\"https:\/\/btechgeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#primaryimage\"},\"datePublished\":\"2022-09-09T07:00:43+00:00\",\"dateModified\":\"2022-09-09T07:21:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/btechgeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"jdbc interview questions and answers for experienced &#8211; Java Database Connectivity (JDBC) Interview Questions in Java\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#webpage\"},\"author\":{\"@id\":\"https:\/\/btechgeeks.com\/#\/schema\/person\/ea8ce699662f0d7e248e52fe080b85bb\"},\"headline\":\"jdbc interview questions and answers for experienced &#8211; Java Database Connectivity (JDBC) Interview Questions in Java\",\"datePublished\":\"2022-09-09T07:00:43+00:00\",\"dateModified\":\"2022-09-09T07:21:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#webpage\"},\"wordCount\":13675,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/btechgeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png\",\"articleSection\":[\"Interview Questions\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/btechgeeks.com\/#\/schema\/person\/ea8ce699662f0d7e248e52fe080b85bb\",\"name\":\"Prasanna\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/btechgeeks.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/174540ad43736c7d1a4c4f83c775e74d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/174540ad43736c7d1a4c4f83c775e74d?s=96&d=mm&r=g\",\"caption\":\"Prasanna\"},\"url\":\"https:\/\/btechgeeks.com\/author\/prasanna\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"jdbc interview questions and answers for experienced - Java Database Connectivity (JDBC) Interview Questions in Java - BTech Geeks","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/","og_locale":"en_US","og_type":"article","og_title":"jdbc interview questions and answers for experienced - Java Database Connectivity (JDBC) Interview Questions in Java - BTech Geeks","og_description":"jdbc interview questions and answers for experienced: List of topic-wise frequently asked java interview questions with the best possible answers for job interviews. Java Database Connectivity (JDBC) Interview Questions in Java Question 1. What is JDBC? Answer: JDBC is a set of Java API for executing SQL statements. This API consists of a set of ... Read more","og_url":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/","og_site_name":"BTech Geeks","article_publisher":"https:\/\/www.facebook.com\/btechgeeks","article_published_time":"2022-09-09T07:00:43+00:00","article_modified_time":"2022-09-09T07:21:16+00:00","og_image":[{"url":"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png"}],"twitter_card":"summary_large_image","twitter_creator":"@btech_geeks","twitter_site":"@btech_geeks","twitter_misc":{"Written by":"Prasanna","Est. reading time":"63 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/btechgeeks.com\/#organization","name":"BTech Geeks","url":"https:\/\/btechgeeks.com\/","sameAs":["https:\/\/www.facebook.com\/btechgeeks","https:\/\/www.instagram.com\/btechgeeks\/","https:\/\/www.linkedin.com\/in\/btechgeeks","https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg","https:\/\/in.pinterest.com\/btechgeek\/","https:\/\/twitter.com\/btech_geeks"],"logo":{"@type":"ImageObject","@id":"https:\/\/btechgeeks.com\/#logo","inLanguage":"en-US","url":"https:\/\/btechgeeks.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","contentUrl":"https:\/\/btechgeeks.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","width":350,"height":70,"caption":"BTech Geeks"},"image":{"@id":"https:\/\/btechgeeks.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/btechgeeks.com\/#website","url":"https:\/\/btechgeeks.com\/","name":"BTech Geeks","description":"Lecture Notes for BTech, BSc Students","publisher":{"@id":"https:\/\/btechgeeks.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/btechgeeks.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#primaryimage","inLanguage":"en-US","url":"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png","contentUrl":"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png","width":539,"height":230,"caption":"Java Database Connectivity (JDBC) Interview Questions in Java chapter 14 img 1"},{"@type":"WebPage","@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#webpage","url":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/","name":"jdbc interview questions and answers for experienced - Java Database Connectivity (JDBC) Interview Questions in Java - BTech Geeks","isPartOf":{"@id":"https:\/\/btechgeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#primaryimage"},"datePublished":"2022-09-09T07:00:43+00:00","dateModified":"2022-09-09T07:21:16+00:00","breadcrumb":{"@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/btechgeeks.com\/"},{"@type":"ListItem","position":2,"name":"jdbc interview questions and answers for experienced &#8211; Java Database Connectivity (JDBC) Interview Questions in Java"}]},{"@type":"Article","@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#article","isPartOf":{"@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#webpage"},"author":{"@id":"https:\/\/btechgeeks.com\/#\/schema\/person\/ea8ce699662f0d7e248e52fe080b85bb"},"headline":"jdbc interview questions and answers for experienced &#8211; Java Database Connectivity (JDBC) Interview Questions in Java","datePublished":"2022-09-09T07:00:43+00:00","dateModified":"2022-09-09T07:21:16+00:00","mainEntityOfPage":{"@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#webpage"},"wordCount":13675,"commentCount":0,"publisher":{"@id":"https:\/\/btechgeeks.com\/#organization"},"image":{"@id":"https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#primaryimage"},"thumbnailUrl":"https:\/\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/Java-Database-Connectivity-JDBC-Interview-Questions-in-Java-chapter-14-img-1.png","articleSection":["Interview Questions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/btechgeeks.com\/java-database-connectivity-jdbc-interview-questions-in-java\/#respond"]}]},{"@type":"Person","@id":"https:\/\/btechgeeks.com\/#\/schema\/person\/ea8ce699662f0d7e248e52fe080b85bb","name":"Prasanna","image":{"@type":"ImageObject","@id":"https:\/\/btechgeeks.com\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/174540ad43736c7d1a4c4f83c775e74d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/174540ad43736c7d1a4c4f83c775e74d?s=96&d=mm&r=g","caption":"Prasanna"},"url":"https:\/\/btechgeeks.com\/author\/prasanna\/"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":3580,"url":"https:\/\/btechgeeks.com\/java-jdbc-driver\/","url_meta":{"origin":15236,"position":0},"title":"Which driver is called as thin-driver in jdbc - Java JDBC Driver | Types of Java Database Connectivity Drivers and Comparson","date":"September 7, 2022","format":false,"excerpt":"Which driver is called as thin-driver in jdbc: JDBC Driver is a software component that is used to interact with the java application with the database. The purpose of JDBC driver is to convert java calls into database-specific calls and database-specific calls into java calls. Types of JDBC Drivers: JDBC-ODBC\u2026","rel":"","context":"In &quot;JAVA&quot;","img":{"alt_text":"JDBC-ODBC bridge Driver","src":"https:\/\/i2.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/04\/JDBC-ODBC-bridge-Driver.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":12107,"url":"https:\/\/btechgeeks.com\/databases-jdbc-interview-questions-in-java\/","url_meta":{"origin":15236,"position":1},"title":"Databases & Jdbc Interview Questions in Java","date":"March 13, 2023","format":false,"excerpt":"We have compiled most frequently asked Java J2EE Interview Questions which will help you with different expertise levels. Java J2EE Interview Questions on Databases & Jdbc Question 1. What do you understand by a database? Answer: A database is a permanent, self-descriptive store of data that is contained in one\u2026","rel":"","context":"In &quot;Interview Questions&quot;","img":{"alt_text":"DATABASES & JDBC Interview Questions in Java chapter 5 img 2","src":"https:\/\/i2.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/07\/DATABASES-JDBC-Interview-Questions-in-Java-chapter-5-img-2.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3590,"url":"https:\/\/btechgeeks.com\/java-mysql-database-connectivity-with-example\/","url_meta":{"origin":15236,"position":2},"title":"Java MySQL Database Connectivity with Example","date":"February 26, 2023","format":false,"excerpt":"In this tutorial, you will learn\u00a0how to connect to MySQL database in java. Here you will learn step by step guide to connect java application with a MySQL database. In order to connect MySQL database from Java, you need JDBC API. By JDBC, you will connect to any type of\u2026","rel":"","context":"In &quot;JAVA&quot;","img":{"alt_text":"connect to a MySQL database using java","src":"https:\/\/i0.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/04\/connect-to-a-MySQL-database-using-java.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3852,"url":"https:\/\/btechgeeks.com\/statement-interface-in-java\/","url_meta":{"origin":15236,"position":3},"title":"Statement Interface in Java - JDBC | Definition, Syntax, and Methods of Statement Interface with Example","date":"March 6, 2023","format":false,"excerpt":"In this tutorial, you will learn Statement Interface in Java-JDBC. With the help of the Statement object, we can send our SQL Query to Database. Furthermore, you will also read Statement interface methods with an example. What is Statement Interface in JDBC? Commonly used Methods of Statement Interface JDBC Statement\u2026","rel":"","context":"In &quot;JAVA&quot;","img":{"alt_text":"Statement Interface in Java","src":"https:\/\/i2.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/05\/Statement-Interface-in-Java.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4224,"url":"https:\/\/btechgeeks.com\/callablestatement-in-java\/","url_meta":{"origin":15236,"position":4},"title":"Callablestatement example java - CallableStatement in Java | How to use a CallableStatement in Java to Call a Stored Procedure?","date":"September 9, 2022","format":false,"excerpt":"Callablestatement example java: CallableStatement in JDBC is an interface present in a java.sql package and it is the child interface of Prepared Statement. Callable Statement is used to execute the Stored Procedure and functions. The driver software vendor is responsible for providing the implementations for the Callable Statement interface. This\u2026","rel":"","context":"In &quot;JAVA&quot;","img":{"alt_text":"CallableStatement in Java","src":"https:\/\/i0.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/05\/CallableStatement-in-Java.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3789,"url":"https:\/\/btechgeeks.com\/difference-between-statement-vs-preparedstatement-vs-callablestatement-in-java\/","url_meta":{"origin":15236,"position":5},"title":"Difference between Statement Vs PreparedStatement Vs CallableStatement in Java | Check Definitions & Example Programs","date":"September 5, 2022","format":false,"excerpt":"Difference between statement preparedstatement and callablestatement: In this tutorial, we will discuss the\u00a0differences between Statement vs PreparedStatement vs CallableStatement\u00a0in detail. Actually, JDBC API implements three diverse interfaces to execute different SQL Queries. They are: Statement: Statement interface is used to execute normal SQL Queries. PreparedStatement: It is used to execute\u2026","rel":"","context":"In &quot;JAVA&quot;","img":{"alt_text":"Difference between Statement Vs PreparedStatement Vs CallableStatement in java","src":"https:\/\/i1.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/04\/Difference-between-Statement-Vs-PreparedStatement-Vs-CallableStatement-in-java.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/posts\/15236"}],"collection":[{"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/comments?post=15236"}],"version-history":[{"count":2,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/posts\/15236\/revisions"}],"predecessor-version":[{"id":37905,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/posts\/15236\/revisions\/37905"}],"wp:attachment":[{"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/media?parent=15236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/categories?post=15236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/tags?post=15236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}