What is a cursor? Why should it be used ?

COBOL SQL Interview Questions

(Continued from previous question...)

What is a cursor? Why should it be used ?

Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time. Cursor should be used because the host language can deal with only one row at a time.

(Continued on next question...)

Other Interview Questions

• Why SELECT * is not preferred in embedded SQL programs ?
• What is the basic differnce between a join and a union?
• What keyword does an SQL SELECT statement use for a string search?
• What is a join?
• What is a correlation name?
• When can an insert of a new primary key value threaten referntial integrity?
• What RDMS objects are required before you can create a table ?
• What keyword does an SQL SELECT statement use for a string search?
• How is the SUBSTR keyword used in SQL?
• After a table is defined, can columns be removed ?
• More...