C2090-730 Web TestEngine demo

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

Given the following set of statements:

CREATE TABLE tab1 (col1 INTEGER, col2 CHAR(20));
COMMIT;
INSERT INTO tab1 VALUES (123, 'Red');
INSERT INTO tab1 VALUES (456, 'Yellow');
SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
DELETE FROM tab1 WHERE col1 = 123;
INSERT INTO tab1 VALUES (789, 'Blue');
ROLLBACK TO SAVEPOINT s1;
INSERT INTO tab1 VALUES (789, 'Green');
UPDATE tab1 SET col2 = NULL WHERE col1 = 789;
COMMIT;

Which of the following records would be returned by the following statement?

SELECT * FROM tab1

Sign in to mark questions

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

Sign in