【OCP-12c】2019年CUUG OCP 071考试题库(79题)

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那么就是正确的。

原文地址:https://www.cnblogs.com/cnblogs5359/p/10551690.html