8/2/2019 Bt0074 Unit 10 Faqs

1/1

Frequently Asked Questions

1

Subject Name: OOPS with Java Subject Code: BT0074

Unit 10: Java Data Base Connectivity (JDBC)Balasubramani R

Assistant ProfessorDept. of IT

Q1: What is JDBC?

A1: The JDBC API (Java Data Base Connectivity Application Program Interface) can access

any kind of tabular data, especially data stored in a relational database. It works on top of

ODBC (Open Data Base Connectivity) which was the driver for database connectivity

since age old days.

Q2: What are the database activities a Java application can do?

A2: 1. Connecting to a data source like a database.

2. Sending queries and updating statements to the database

3. Retrieving and processing the results received from the database in answer to your

query.

Q3: What is DBMS? Give some examples.

A3: A database is a collection of related information and a Data Base Management System

(DBMS) is the software that provides you with a mechanism to manipulate data in the

database. Examples: MS-Access, MS-SQL Server, Oracle, Sybase and Ingres.

Q4: What is the function of JDBC Driver Manager?

A4: The JDBC Driver Manager is the backbone of the JDBC architecture. The function of the

JDBC driver manager is to connect a Java application to the appropriate driver.

Q5: What is java.sql?

A5: java.sql is a Java package, that contains classes that help in connecting to a database,

sending SQL statements to the database, and processing query results.