Question

The SQL statements executed in a user session as follows: create table product(pid number(10),pname varchar(10)); Insert into product values(1,'pendrive'); Insert into product values(2,'harddisk'); savepoint a; update product set pid=20 where pid=1; savepoint b; delete from product where pid=2; commit; delete from product where pid=10; Which statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session?

Answer 1

Answer: No SQL statements are rolled back., The rollback generates an error.

Explanation:

Once you commit all the save points before the commit are erased as the commit ensure that effect of all statements before commit are made permanent on the disk.

So when you ROLLBACK TO SAVE POINT a it will generate error as there is no save point a.

that's why NO SQL statements will be rolled back.

Answer 2

Answer:

No SQL statements are rolled back.

Explanation: