JDBC Interview Questions for Freshers or Experienced Pdf - 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
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
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).
Describe how the JDBC application works?
A JDBC application may be divided into two layers.
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.
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.
7000+ TNPSC Group 1, 2, 4, VAO Indian Economy Study Materials Pdf More
7000+ Gate Computer Science Engineering Previous Year Questions More
7000+ Fill in the Blanks with Suitable Homonyms More
7000+ Fill in the Blanks with Suitable Homophones More
Power Semiconductor Device and Integrated Circuits MCQ Questions Pdf More
1000+ Advanced Excel MCQ Questions and Answers Pdf More
100+ Data Interpretation Questions with Solutions for Bank PO Pdf More
Delhi Sultanate Online Test Questions for UPSC, SSC CGL More
100+ SBI Computer Knowledge Questions and Answers Pdf More
Java Interview Questions and Answers More