Oracle Exam 1Z0-062 Topic 4 Question 59 Discussion

Examine these statements:

DESC emp

INSERT INTO emp VALUES ( 101, 'John', 12000);

1 row created.

SAVEPOINT after_insert;

Savepoint created.

UPDATE emp SET salary=16000 WHERE empno=101;

1 row updated.

SAVEPOINT after_update;

Savepoint created.

DELETE FROM emp WHERE empno=101;

1 row deleted.

SAVEPOINT after_delete;

Savepoint created.

ROLLBACK TO SAVEPOINT after_update;

Rollback complete.

INSERT INTO emp VALUES ( 102, 'Emma', 12000);

ROLLBACK TO SAVEPOINT after_delete;

Which is the result and effect of this ROLLBACK?