Is DECLARE CURSOR executable?

COBOL SQL Interview Questions

(Continued from previous question...)

Is DECLARE CURSOR executable?

No

(Continued on next question...)

Other Interview Questions

• What is UNION, UNION ALL?
• What are the column name qualifiers?
• What do you accomplish by GROUP BY ... HAVING clause ?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• Is BETWEEN inclusive of the range values specified?
• We have a table with a CHARACTER data type field
• What is a cursor? Why should it be used ?
• What is a synonym?
• What RDMS objects are required before you can create a table ?
• How would you retrieve row from a DB2 table in embedded SQL?
• More...