OCP 1Z0 051 172

172. The SQL statements executed in a user session are as follows: 
SQL> CREATE TABLE product      
(pcode   NUMBER(2),       
pname   VARCHAR2(10)); 
SQL> INSERT INTO product   VALUES (1, 'pen'); 
SQL> INSERT INTO product   VALUES (2,'pencil'); 
SQL> SAVEPOINT a; 
SQL> UPDATE product SET pcode = 10 WHERE pcode = 1; 
SQL> SAVEPOINT b; 
SQL> DELETE FROM product   WHERE pcode = 2; 
SQL> COMMIT; 
SQL> DELETE FROM product WHERE pcode=10; 
Which  two  statements  describe  the  consequences  of  issuing  the  ROLLBACK  TO  SAVE  POINT  a 
command in the session? (Choose two.) 
A. The rollback generates an error. 
B. No SQL statements are rolled back. 
C. Only the DELETE statements are rolled back. 
D. Only the second DELETE statement is rolled back. 
E. Both the DELETE statements and the UPDATE statement are rolled back. 

事务结束后 之前的savepoint 不可再用。

SQL> DROP TABLE product PURGE;Table droppedSQL> CREATE TABLE product  2  (pcode   NUMBER(2),  3  pname   VARCHAR2(10));Table createdSQL> INSERT INTO product   VALUES (1, 'pen');1 row insertedSQL> INSERT INTO product   VALUES (2,'pencil');1 row insertedSQL> SAVEPOINT a;Savepoint createdSQL> UPDATE product SET pcode = 10 WHERE pcode = 1;1 row updatedSQL> SAVEPOINT b;Savepoint createdSQL> DELETE FROM product   WHERE pcode = 2;1 row deletedSQL> COMMIT;Commit completeSQL> DELETE FROM product WHERE pcode=10;1 row deletedSQL> ROLLBACK TO SAVEPOINT a;ROLLBACK TO SAVEPOINT a

Answer: AB