Question of the Day

Wednesday, 23 September 2009


What are the disadvantages of cursors?


1. Cursor results in a network roundtrip
2. Cursor requires more resources and temporary storage
3. Cursor results in more IO operations
4. 1 & 2
5. 1, 2 & 3
6. None

2 comments:

Prasanna Aaron said...

Option 4(1&2)

The correct answer is:

5. 1,2 & 3

Explanation:
Cursor also results in more IO operation.