| |
GeekInterview.com > Interview Questions > Mainframe > DB2
| Print | |
Question: what is the result of the following statement?
Answer: Given the following transaction in an embedded SQL application:
CREATE TABLE dwaine.mytab (col1 INT, col2 INT)
INSERT INTO dwaine.mytab VALUES (1,2)
INSERT INTO dwaine.mytab VALUES (4,3)
ROLLBACK
What is the result of issuing the following statement?
SELECT * FROM dwaine.mytab
|
| July 07, 2008 05:04:15 |
#1 |
| dumpetikalyan |
Member Since: July 2008 Total Comments: 1 |
RE: what is the result of the following statement?
|
Zero (0) rows returned.
Note: If you do any rollback all the DML commands will be rolled back (like Undo) until the previous commit point. Rollback is no effect on DDL commands. Once DDL commands are executed those are permanant in database.
Hope this help's |
| |
Back To Question | |
