Distinguish between the four cursor types. What will be an ...

[crobinson2013]

Distinguish between the four cursor types.
 
  What will be an ideal response?

Question 2

Which of the following is not a true statement about the current version of UML?
 
  A) UML places a filled-in diamond on the parent of a weak entity.
  B) UML provides a means to document exclusivity among subtypes.
  C) UML uses the label to document an ID-dependent relationship.
  D) UML shows the cardinality on the parent entity of a weak entity as simply 1.

[ttt030911]

Answer to Question 1

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.

Answer to Question 2

B