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.
Only the seconds DELETE statement is rolled back
B.
No SQL statements are rolled back
C.
The rollback generates an error
D.
Both the DELETE statements and the UPDATE statement are rolled back
E.
Only the DELETE statements are rolled back
CREATE TABLE product
(pcode NUMBER(2),
pname VARCHAR2(10));
INSERT INTO product VALUES(1,’pen’);
INSERT INTO product VALUES(2,’pencil’);
SAVEPOINT a;
UPDATE product SET pcode = 10 WHERE pcode = 1;
SAVEPOINT b;
DELETE FROM product WHERE pcode = 2;
COMMIT;
DELETE FROM product WHERE pcode = 10;
ROLLBACK TO SAVE POINT a;
Table PRODUCT criado.
1 linha inserido.
1 linha inserido.
SAVEPOINT a
1 linha atualizado.
SAVEPOINT b
1 linha excluído.
Commit concluído.
1 linha excluído.
01086. 00000 – “savepoint ‘%s’ never established in this session or is invalid”
*Cause: An attempt was made to roll back to a savepoint that was never
established in this session, or was invalid.
*Action: Try rolling back to the savepoint from the session where it is established.