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)It requires the greatest overhead of any cursor type.

Question

Quizplus · Accepted Answer

Forward-only cursors only see changes made by the transaction if those changes occur on rows ahead of the cursor's current position. This is because forward-only cursors can only move in one direction, from the beginning to the end of the cursor's dataset, and do not support scrolling back to previous rows to see changes.

Which of the Following Is True of Forward Only Cursors