Chapter 17

Question 1

What is meta data

Answer 1

Data about data

Question 2

getColumncount() do what

Answer 2

Returns total number of columns in resultset

Question 3

How we can get JDBC driver name is java

Answer 3

getDriverName()

Question 4

Can we manipulate database after closing connection

Answer 4

Yes

Question 5

What is RowSet

Answer 5

They exist in java standard extension javax. They work in 2 modes. RowSet are like resultset. The difference is that when we manipulate rowset it works with closed connection of database. It works in a way that it makes a copy in memory and do processing on client end. It is very flexible.

Question 6

What are types of rowset

Answer 6

• Cached rowset
• JDBC rowset
• Web rowset
• Filter rowset
• Join rowset

Question 7

What is JDBC rowset

Answer 7

It is a wrapper on resultset. It has all functionality of rowset but underlying there was resultset.

Question 8

What is type 1 driver

Answer 8

JDBC-ODBC bridge. It translate JDBC calls to ODBC. ODBC is from Microsoft and JDBC is from Java. The flow is that JDBC-ODBC bridge talks to ODBC driver. Then ODBC driver talks to vendor DB library. Then vendor DB library talks to database server.

Question 9

What is type 2 driver

Answer 9

Native - API/partly java driver. It is just like type 1 driver with the difference the layer of ODBC driver is removed in it.

Question 10

What is type 4 driver

Answer 10

Native - protocol/all-java driver. It is most fastest driver because it communicates directly to database server. It flow is like this: Native protocol pure java driver talks to database server. It is thin driver.

Question 11

What is type 3 driver

Answer 11

Net - protocol/all-java driver. It is for network. It flow is like this client machine (Net - protocol/all-java driver) talks to server machine and server machine talk to database server with the help of any type 1, 2, 4 driver