JDBC Interview Questions

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

JDBC Interview questions with answers

Describe how JAVA interact with JDBC. What are the components of JDBC? How do we access non-relational source using JDBC? Describe how to call stored procedure using JDBC. What are different types of resultset in JDBC? Answer - Resultset contains results of the SQL query..... What are different transaction levels in JDBC? Answer - Transaction Isolation levels is used to implement locking..... Explain optimistic and pessimistic locking in JDBC. Answer - There are two kinds of locking available in JDBC..... JDBC Interview - July 31, 2008, 17:35 pm by Amit Satpute What causes the "No suitable driver" error? Answer - Failure to load the appropriate JDBC driver before giving a call to ..... Is the JDBC-ODBC Bridge multi-threaded? Answer - NO. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls.... What is an SQL Locator? Answer - DBMS uses the logical pointers as identifiers to locate and manipulate the data...... What is optimistic concurrency control? Answer - In optimistic concurrency control, locks are granted without performing conflict checks...... What is pessimistic concurrency? Answer - In this approach, each transaction is assigned a timestamp. One can make sure that they..... Why doesn't JDBC accept URLs instead of a URL string? Answer - The URLs need to be converted to strings as there is no single universal protocol to treat the URLs..... What JDBC objects generate SQLWarnings? Answer - Connections, Statements and ResultSets generate SQLWarnings through getWarnings method...... How do I create an updatable ResultSet? Answer - For the results to be updatable, the Statement object used to create the result sets..... How do I insert an image file (or other raw data) into a database? Answer - Upload all raw data-types (like binary documents) to the database as an array of..... What is the advantage of using a PreparedStatement? Answer - There are two kinds of locking available in JDBC..... What’s the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE? Answer - Constant indicating that the type for a ResultSet object is scrollable.... What are the different types of RowSet? Answer - Connected: A connected RowSet Object is permanent in nature. It doesn’t terminate..... How can you retrieve data from the ResultSet? Answer - Create a result set containing all data from..... What is a non-repeatable read? Answer - A Non-repeatable read is where one transaction cannot read the second time..... What is phantom read? Answer - If you execute a query at time T1 and re-execute it at time T2, additional rows may have..... Advantages of JDBC. Answer - Businesses can continue to use their installed databases and access..... What will Class.forName do while loading drivers? Answer - When you have loaded a driver, it is available for making a connection with a DBMS...... What are the different types of driver? Answer - Type 1...... What are the standard isolation levels defined by JDBC? Answer - The values are defined in the class java.sql.Connection and are: ...... How do we call stored procedure using JDBC?