What is the result of the following statement?

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

Questions by suvidha

Showing Answers 1 - 4 of 4 Answers

dumpetikalyan

  • Jul 15th, 2008
 

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions