OCP-1Z0-051-V9.02-175题

175. Which two statements are true regarding savepoints? (Choose two.)

A. Savepoints are effective only for COMMIT.

B. Savepoints may be used to ROLLBACK. 

C. Savepoints can be used for only DML statements. 

D. Savepoints are effective for both COMMIT and ROLLBACK.  

E. Savepoints can be used for both DML and DDL statements. 

Answer: BC   

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12885143

A，保存点只对COMMIT有效，错误，只对ROLLBACK

B，保存点可以用于ROLLBACK，正确。

C，保存点只能用于DML语句，正确。

D，保存点对于COMMIT和ROLLBACK都有效，错误。只对ROLLBACK。

E，保存点可以用于DML和DDL语句，错误。DDL语句不行，DDL相当于commit，commit后不能回滚。

保存点只能用于DML语句，并且只用于ROLLBACK。