OCP认证051考试题库：11g-v9.02-第172题

OCP认证051考试题库：11g-v9.02-第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.

Answer: AB

试题解析：

由于COMMIT命令提交后之前建立的保存点都变成无效的了。

ROLLBACK TO SAVEPOINT a;命令报错后，只会影响本身这条语句，不会影响其它语句，所以第二个DELETE语句不会回滚。