博客围绕事务相关问题展开，给出题目询问关于事务的正确陈述。选项涉及DML、DDL语句与事务的关系，如一组DML语句以SAVEPOINT结尾、每个DDL语句执行、一组DDL语句以COMMIT结尾、DDL和DML语句组合以COMMIT结尾等情况。正确答案是每个DDL语句执行形成单个事务，因DDL语句执行后自动提交。
79、Which statement is true about transactions?
A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.
B. Each Data Definition Language(DDL) statement executed forms a single transaction.
C. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.
D. A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.
Correct Answer: B
Section: (none) Explanation：每个DDL语句都是一个事务，因为DDL语句执行后自动提交。如果A答案SAVEPOINT改为COMMIT或者ROLLBACK那么就是正确的。
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
