Which layer of database testing does JDBC interact with?

• A. Presentation layer
• B. Application layer
• C. Database layer
• D. Data Access layer

Answer: (C)

JDBC, or Java Database Connectivity, operates at the Data Access layer of application architecture. This layer is responsible for interacting directly with the databases to perform operations such as querying, updating, and managing data. JDBC serves as an API that facilitates the communication between Java applications and various databases, enabling developers to execute SQL statements and retrieve results.

In the context of database testing, JDBC enables automated testing frameworks to interact with the database directly, validating data integrity, retrieval, and operations conducted by the application. This capability is crucial for ensuring that the underlying database functions effectively and responds correctly to requests from the application layer, thereby achieving proper data management throughout the system.

The other layers mentioned, such as the Presentation layer and Application layer, do not directly pertain to JDBC's function. The Presentation layer is concerned with the user interface and how data is presented to users, while the Application layer involves the business logic of the application. The database layer refers more to the physical structure and management of data storage rather than the API that accesses the data. The Data Access layer specifically highlights where JDBC fits into this architecture, making it the most accurate answer.