Which of the following is true of forward only cursors?
A) Current values for each row are retrieved when the application accesses a row.
B) All changes of any type from any source are visible.
C) Changes made by the transaction are visible only if they occur on rows ahead of the cursor.
D) Applications may scroll backward in the record set.
E) It requires the greatest overhead of any cursor type.
Correct Answer:
Verified
Q48: A database save is used to mark
Q54: Copies of each database record or page
Q55: The DBA should periodically analyze run-time statistics
Q57: Processing rights may be implemented at the
Q58: To support rollforward and rollback recovery,transactions must
Q62: Locks that are placed assuming that a
Q63: A series of actions to be taken
Q64: Requiring all application programs to lock resources
Q65: One remedy for the inconsistencies caused by
Q66: Which type of lock still allows other
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents