1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

JDBC interview questions

  • Image upload from JSP to DataBase ? view answer
  • How to Upload Image into Data Base ? view answer
  • Q. What is Rowset ? CachedRowSet,JDBCRowSet and WebRowSet ? view answer
  • Q. What is Batch Updates Using Statements in JDBC ? view answer
  • Q.Handling Blob and CLOB data using JDBC ? Insert CLOB and Retrive CLOB , Convert into String ? view answer
  • Q. Calling Stored procedures with Callable Statement ? view answer
  • Q.What is JDBC ? Explain Types Of Drivers with Advantage and Disadvantage ? view answer
  • Q. How java retrive the result returns from stored procedure ? view answer
  • Q.How to retrive the results in java returned by refcursor in Stored procedure ? view answer
  • Q.Reading an Oracle ARRAY from a stored procedure as an out ? view answer
  • What is Metadata and why should I use it? view answer
  • How Class.forName() load the Driver and DriverManager.getConnection() return connection? view answer
  • What will Class.forName do while loading drivers? view answer
  • How to Determining If a Result Set Is Scrollable? view answer
  • How Getting the Number of Rows in a Table Using a Scrollable Result Set? view answer
  • What is Scrollable Result Set ? view answer
  • What does setAutoCommit do? view answer
  • What is the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE? view answer
  • How to Make Updates to Updatable Result Sets? view answer
  • How can you move the cursor in scrollable result sets? view answer
  • What are the different types of Statements with Example? view answer
  • How can you retrieve data from the ResultSet? view answer
  • How can you create JDBC statements and what are they? view answer
  • How can you make the connection? view answer
  • What will Class.forName do while loading drivers? view answer
  • How can you load the drivers? view answer
  • What is PreparedStatement ? view answer
  • what is rowset? and how does it differ from resultset ? view answer
  • How to find total column from a resultset? view answer
  • What is the fastest type of JDBC driver? view answer
  • What are the different JDB drivers available? view answer
  • Q.What are collection pools? What are the advantages? view answer
  • Q.What are different types of Transaction Isolation Levels? view answer
  • Q. What is Dirty read? view answer
  • Q.Difference between Statement , PreparedStatement and CallableStatement ? view answer
  • Q.What is the advantage of using PreparedStatement? view answer
  • Q.What is Single-Phase Commit ? view answer
  • Q.What is two-phase commit? view answer
  • Q. How JDBC work with REF CURSOR returned by stored procedure and retrive results? view answer
  • Q. How do i get result return from stored procedure in JDBC? view answer
  • Q.How do you call a Stored Procedure from JDBC? view answer
  • Q.How do you handle your own transaction ? view answer
  • Q.What are the steps in the JDBC connection? view answer

!!! JDBC interview questions !!!

Q.What is JDBC ? Explain Types Of Drivers with Advantage and Disadvantage ?



Java Database Connectivity(JDBC) defines how a java program can communicate with a database. JDBC API has two major packages java.sql and javax.sql.
There are 4 types of JDBC drivers available.
1)    Type 1 Driver- the JDBC-ODBC bridge :
The JDBC type 1 driver, also known as the JDBC-ODBC bridge is a database driver implementation that the ODBC driver to connect to the database. The driver converts JDBC method calls into ODBC function calls. The bridge is usually used when there is no pure-Java driver available for a particular database.
The driver is implemented in the sun.jdbc.odbc.JdbcOdbcDriver class .
The driver is platform-dependent as it makes use of ODBC which in turn depends on native libraries of the operating system.
Advantage :
Almost any database for which ODBC driver is installed, can be accessed.
Disadvantage :
a)    Performance overhead since the calls have to go through the JDBC overhead bridge to the ODBC driver.
b)    The ODBC driver needs to be installed on the client machine
c)    considering the client-side software needed, this might not be suitable for applets.


2)    Type 2 Driver - the Native-API Driver :
The JDBC type 2 driver, also known as the Native-API driver is a database driver implementation that uses the client-side libraries of the database. The driver converts JDBC method calls into native calls of the database API.
The type 2 driver is not written entirely in Java as it interfaces with non-Java code that makes the final database calls.

A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for ORACLE, DB2 or other . Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine.
However the type 2 driver provides more functionality and performance than the type 1 driver as it does not have the overhead of the additional ODBC function calls.

Advantage:
Better performance than Type 1 since no jdbc to odbc translation is needed

Disadvantage :
a)    The vendor client library needs to be installed on the client machine.
b)    Cannot be used in internet due the client side software needed
c)    Not all databases give the client side library

3)    Type 3 driver - the Network-Protocol Driver:
The JDBC type 3 driver, also known as the network-protocol driver is a database driver implementation which makes use of a middle-tier between the calling program and the database. The middle-tier (application server) converts JDBC calls directly or indirectly into the vendor-specific database protocol.

Advantages:
a)    Since the communication between client and the middleware server is database independent, there is no need for the vendor db library on the client machine.
b)    The Middleware Server (Can be a full fledged J2EE Application server) can provide typical middleware services like caching (connections, query results, and so on), load balancing etc.
Disadvantages :
a)    Requires database-specific coding to be done in the middle tier.
b)    An extra layer added may result in a time-bottleneck


4)    Type 4 - the Native-Protocol Driver :
The JDBC type 4 driver, also known as the native-protocol driver is a database driver implementation that converts JDBC calls directly into the vendor-specific database protocol.
The type 4 driver is written completely in Java and is hence platform independent. It is installed inside the Java Virtual Machine of the client. It provides better performance over the type 1 and 2 drivers as it does not have the overhead of conversion of calls into ODBC or database API calls. Unlike the type 1 and 2 drivers, it does not need associated software to work..

Advantages :
a) These drivers don't translate the requests into db request to ODBC or pass it to client api for the db, nor do they need a middleware layer for request indirection. Thus the performance is considerably improved.
b) Web application mainly used this driver.
Disadvantage:
At client side, a separate driver is needed for each database. ex- classes12.zip (for ORACLE)

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy