Understanding JDBC: Which statement about Java Database Connectivity (JDBC) is accurate with respect to purpose and design?
-
AIt is language independent.
-
BIt is similar in concept to ODBC.
-
CIt is useful for all object-oriented languages.
-
DIt consists of three main layers.
Answer
Correct Answer: It is similar in concept to ODBC.
Explanation
Introduction / Context:JDBC is the standard Java API for interacting with relational databases. It abstracts vendor-specific protocols via drivers, allowing Java applications to execute SQL and manage connections in a portable way.
Given Data / Assumptions:
- Audience: Java developers connecting to RDBMS systems.
- JDBC defines interfaces and classes in the Java language.
- Vendors supply JDBC drivers that implement the API.
Concept / Approach:
JDBC is conceptually similar to ODBC (Open Database Connectivity) in that both define a standard interface to access different databases through drivers. However, JDBC is Java-specific; it is not language independent and is not intended for non-Java languages.
Step-by-Step Solution:
Identify the role of JDBC: a Java API to issue SQL, manage connections, handle results.Compare with ODBC: both use drivers to hide vendor specifics.Conclude that “similar in concept to ODBC” is accurate.Verification / Alternative check:
Review JDBC architecture diagrams showing JDBC API → Driver Manager → JDBC Driver → DBMS, analogous to ODBC APIs and drivers.
Why Other Options Are Wrong:
Language independent / useful for all OO languages: false; JDBC is for Java.
Three main layers: oversimplification and not a canonical truth for JDBC itself.
Common Pitfalls:
Confusing the JDBC-ODBC bridge (deprecated) with general JDBC usage; assuming drivers behave identically across vendors without testing.
Final Answer:
It is similar in concept to ODBC.