DYNAMIC:

It reflects changes happened on the table while scrolling through the row.

STATIC:

• It works on snapshot of record set and disconnects from the server.
• This kind doesn’t  reflects changes happened on the table while scrolling through the row. 

KEYSET:

In this kind, new record is not reflected, but data modification can be seen.