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

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

试题解析：

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

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

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

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

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

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