1. What is JDBC?

Answer
JDBC may stand for Java Database Connectivity. It is also a trade mark. 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

2. What are the two major components of JDBC?

Answer
One implementation interface for database manufacturers, the other implementation interface for application and applet writers.

3. What is JDBC Driver interface?

Answer
The JDBC Driver interface provides vendor-specific implementations of the abstract classes provided by the JDBC API. Each vendors driver must provide implementations of the java.sql.Connection,Statement,PreparedStatement, CallableStatement, ResultSet and Driver.

4. What are the common tasks of JDBC?

Answer

• Create an instance of a JDBC driver or load JDBC drivers through jdbc.drivers
• Register a driver
• Specify a database
• Open a database connection
• Submit a query
• Receive results

5. What are four types of JDBC driver?

Answer

1. Type 1 Drivers : Bridge drivers such as the jdbc-odbc bridge. They rely on an intermediary such as ODBC to transfer the SQL calls to the database and also often rely on native code.

2. Type 2 Drivers : Use the existing database API to communicate with the database on the client. Faster than Type 1, but need native code and require additional permissions to work in an applet. Good for client-side connection.

3. Type 3 Drivers : Call the database API on the server.Flexible. Pure Java and no native code.

4. Type 4 Drivers : The hightest level of driver reimplements the database network API in Java. No native code.