Consider the table demo with below data.
demo:
col1 | col2 | col3
------+------+------
1 | 10 | 100
2 | 20 | 200
3 | 30 | 300
After executing below query what would be the data present in demo table?
Note: AUTOCOMMIT is ON.
BEGIN;
Insert into demo values(4,40,400);
update demo set col2=55 where col1=2;
delete from table demo where col1=4;
END;

Question

Consider the table demo with below data.

demo:

col1 | col2 | col3

------+------+------

1 | 10 | 100

2 | 20 | 200

3 | 30 | 300

After executing below query what would be the data present in demo table?

Note: AUTOCOMMIT is ON.

BEGIN;

Insert into demo values(4,40,400);

update demo set col2=55 where col1=2;

delete from table demo where col1=4;

END;

anonymous · Accepted Answer

Correct Solution - d

Important Links