What is a cursor? Why should it be used ?

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• What is meant by locking?
• What is a join?
• What are the column name qualifiers?
• In what RDMS object does one first list column names ?
• What is minimum authority required for one to create a tablespace?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• What happens when you say OPEN CURSOR?
• What is referential integrity?
• What is a results table?
• What is the difference between group by and order by ?
• More...