IBM Exam Questions

Which of the following is the last value obtained for COL_2?

Given the following table:
TAB1
COL1 COL2
—– —–
A 10
B 20
C 30

D 40
E 50
And the following SQL statements:
DECLARE c1 CURSOR WITH HOLD FOR
SELECT * FROM tab1 ORDER BY col_1;
OPEN c1;
FETCH c1;
FETCH c1;
FETCH c1;
COMMIT;
FETCH c1;
CLOSE c1;
FETCH c1;
Which of the following is the last value obtained for COL_2?

A.
20

B.
30

C.
40

D.
50