MOHARA interview question

Explain a cursor and how it is used in SQL