The SQL statements executed in a user session as follows:
Exhibit:
Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in
the session? (Choose two.)
A.
Both the DELETE statements and the UPDATE statement are rolled back
B.
The rollback generates an error
C.
Only the DELETE statements are rolled back
D.
Only the seconds DELETE statement is rolled back
E.
No SQL statements are rolled back
B,E
——————————————————————–
SQL> create table product(pcode number(2),pname varchar2(10));
Table created.
SQL> insert into product values(1,’A’);
1 row created.
SQL> insert into product values(2,’B’);
1 row created.
SQL> savepoint a;
Savepoint created.
SQL> update product set pcode=10 where pcode=1;
1 row updated.
SQL> savepoint b;
Savepoint created.
SQL> delete from product where pcode=2;
1 row deleted.
SQL> commit;
Commit complete.
SQL> delete from product where pcode=10;
1 row deleted.
SQL> rollback to savepoint a;
rollback to savepoint a
*
ERROR at line 1:
ORA-01086: savepoint ‘A’ never established