Chapter 14

Question 1

What is JDBC

Answer 1

Java database connectivity provides standard library for accessing relational databases. Its a standardize way to connect with database.

Question 2

What is the package for JDBC

Answer 2

java.sql

Question 3

What is DSN

Answer 3

Data source name

Question 4

What is UDSN

Answer 4

User data source name

Question 5

What is SDSN

Answer 5

System data source name

Question 6

What are basic steps for using JDBC

Answer 6

1- Import required packages
2- Load driver
3- Define connection URL
4- Establish connection
5- Create a statement object
6- Execute query or DML
7- Process results
8- Close connection

Question 7

What is ODBC

Answer 7

open database connectivity is an open standard API for accessing a database by Microsoft.

Question 8

What is JDBC ODBC bridge

Answer 8

Using them together

Question 9

Does result set have getter method

Answer 9

Yes

Question 10

Does opened database connection treat as garbage collection

Answer 10

No. We should close them by ourselves