What is cursor? Explain them briefly and how many types of cursors and give one real time example?

A cursor is a datatype in SQL.

You can use it to loop over a result set.

More info here:

https://msdn.microsoft.com/en-us/library/ms181441.aspx