C2090-730 Web TestEngine demo

Exit VCEDump C2090-730 DB2 9 Family Fundamentals
Question 43 of 46
0% complete
Q43 Single choice

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?

Sign in to mark questions

Sign in to save marked questions and return to this demo.

Sign in