JDBC Interview Questions for Freshers or Experienced Pdf - 1
Question: 1
What are the common tasks of JDBC?
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
Question: 2
Name the new features added in JDBC 4.0?
The major features introduced in JDBC 4.0 are
Auto loading by JDBC driver class
Enhanced Connection management
RowId SQL enabled
Dataset implemented by SQL by using Annotations
Enhancements of SQL exception handling
Supporting SQL XML files
Question: 3
What type of driver did you use in project?
JDBC – 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).
Question: 4
Describe how the JDBC application works?
A JDBC application may be divided into two layers.
Driver layer
Application layer
The Application layer begins after putting a request to the Driver Manager for the connection.
An appropriate driver is chosen and used for establishing the connection.
This connection is linked to the application layer.
The application needs the connection for creating the Statement kind of objects by which the results are obtained.
Question: 5
How JDBC API is common to all the database and also to all drivers?
JDBC API uses Factory method and Abstract Factory Design pattern 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 implementation for the above said interfaces.
Signals and Systems Quiz Questions and Answers Pdf More
Signals and Systems MCQ Questions and Answers Pdf More
Electrical Power Sources Quiz Questions & Answers Pdf More
Electromagnetic Field Theory Question Bank 2024-2025 More
Power Semiconductor Device and Integrated Circuits Questions More
1000+ Strength of Materials Multiple Choice Questions and Answers More
Vb.Net Practical - Viva Questions and Answers More
100+ Geography Natural Regions of the World Questions Answers More
10+ Missing Letter Series Puzzle Questions with Answers More
1000+ Automobile Engineering Objective Questions with Answers More