本文讨论了数据库事务中的SAVEPOINT概念，指出SAVEPOINT允许在事务中设置多个回滚点。Rolling back to a SAVEPOINT可以撤销诸如DELETE、UPDATE等操作，但不能撤销如CREATE INDEX或TRUNCATE这样的DDL语句。同时，一个事务中可以设置多个SAVEPOINT，并且使用SAVEPOINT不会隐式提交事务。
9.Which two statements are true regarding a SAVEPOINT? (Choose two.)
A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
C. Only one SAVEPOINT may be issued in a transaction
D. A SAVEPOINT does not issue a COMMIT
E. Rolling back to a SAVEPOINT can undo a DELETE statement
Source：cuug
扫一扫
3975
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
