> > >

DB2 Administration MCQs

Given the code: EXEC SQL DECLARE cursor1 CURSOR FOR SELECT name, age, b_date FROM person; EXEC SQL OPEN cursor1; Under which of the following situations will the above cursor be implicitly closed?

When there are no rows in the result set

When a COMMIT statement is issued

When a CLOSE statement is issued

When an OPEN Statement is issued

Answer

Correct Answer: When a COMMIT statement is issued

Explanation:

Note: This Question is unanswered, help us to find answer for this one

DB2 Administration Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it