Explain the di?erence between STATIC and KEYSET_DRIVEN cursors.
What will be an ideal response?
STATIC cursors e?ectively make a copy of the result set and scroll through that copy. Thus they cannot see any subsequent changes to the result set. KEYSET_DRIVEN cursors return pointers to the items in the result set and can see subsequent changes to those tuples. Also KEYSET_DRIVEN cursers can be used to update data while STATIC cursors cannot.
You might also like to view...
To change the font for a range of cells, click the _____ cell, then drag the mouse to select the cells.
A. bottom-left B. upper-left C. bottom-right D. upper-right
A(n) ____________________ account is an electronic mailbox that you receive from an email service provider.
Fill in the blank(s) with the appropriate word(s).
When referential integrity is enforced, you cannot enter a(n) ________ key in a related table unless the primary key exists in the primary table
Fill in the blank(s) with correct word
________ view displays the document in its final form with all proposed changes included and the comments hidden
A) Simple Markup B) No Markup C) All Markup D) Original