When you COMMIT, is the cursor closed?

COBOL SQL Interview Questions

(Continued from previous question...)

When you COMMIT, is the cursor closed?

Yes

Other Interview Questions

• Describe a primary key?
• Any SQL implementation covers data types in couple of main categories. Which of the following are those data types?
• How do you specify and use a cursor in a COBOL program?
• Is DECLARE CURSOR executable?
• What is a Cartesian product?
• Is DECLARE CURSOR executable?
• Where in a table are added column located ?
• Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...
• What RDMS objects are required before you can create a table ?
• In the WHERE clause what is BETWEEN and IN?
• More...