21/01/25 ----------- Q)What is JDBC Architecture? =>Client-Server Architecture DIAGRAM Q)What is a JDBC Client? =>Resources sake request making program/software/process is known as a client. =>Any Java applications that requests the database server for CRUD operations using JDBC technology is known as a JDBC client. Q)What is JDBC API? =>Application Programming Interface is nothing but a collection of library methods. =>A collection of library methods of java.sql package that are used for perfroming CRUD operations with the database is nothing but JDBC API. Q)What is DriverManager? =>DriverManager is a database connection factory. I.e. it provides database connections to JDBC clients. =>Once DriverManager provides the database connection to the JDBC client, its role ends. It doesn't participate in CRUD operations. Q)What is JDBC driver? =>JDBC driver is a translation software written in Java according to JDBC specification. =>JDBC driver perfroms the following activities. 1)creating the database connection 2)receiving the JDBC method call from the Java application, translating it into SQL call and passing on the same to the database server. 3)Receiving the result of the CRUD operation from the Database server, translating it into Java format and handing over to the Java application. Q)What is database? =>A collection tables and associated data in those tables is nothing but the database of the project. Q)What is a server? =>A software that provides requested resources to clients is nothing but a server. Q)What is a database server? =>DBMS(Database Management System) software is nothing but database server. =>database is hosted onto the database server. =>Any JDBC client requests the database server to perform CRUD operations with database. DIAGRAM