What is a cursor?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a cursor?

A cursor is a named control structure used to make a set of rows available to a program. DB2 is the relational database system that runs in MVS environment. It was developed by IBM and interfaces with SQL. With the use of SQL DB2. databases can be accessed by wide range of host languages. SQL is the relational database application language " that interfaces with DB2. Because of its capabilities, SQL and. in turn, DB2 have gained considerable acceptance. Thus, a working knowledge of DB2 increases one's marketablility.

(Continued on next question...)

Other Job Interview Questions

• What is the retriction on using UNION in embedded SQL?
• How would you find out the total number of row in a table?
• Is BETWEEN inclusive of the range values specified?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• What is meant by locking?
• What is a Cartesian product?
• What is the syntax for a CREATE TABLE statement ?
• What authority is required to create a table?
• What happens when you say OPEN CURSOR?
• What happens when you say OPEN CURSOR?
• More...