Application of cursors in different applications

I am in a dilemma in thinking how different types of cursors are useful in applications.
like dynamic scrollable cursors are used where result set changes are reflected like in airline reservation system..
but can you tell me the usage of insensitive scrollable cursor(in which application) in real world..
and when to use unscrollable cursors(even though scrollable are available) in realtime applications...