Distinguish between the four cursor types

What will be an ideal response?

Forward only cursors are the simplest type of cursor, and only allow the application program to move forward through the record set. The three other types of cursors are all scrollable cursors, meaning that the application program can move forward and backward through the record set. Static cursors take a snapshot of the relation at the point in time when the cursor was opened. Keyset cursors save a copy of the primary key value for each record in the cursor. This key value is then used to retrieve the values of each record as the application program accesses that record. Dynamic cursors are fully functional cursors and can see any changes made to the records by any committed transactions.