【2019年8月】OCP 071认证考试最新版本的考试原题-第22题

Choose two

Which two statements are true about transactions in the oracle Database serve?

A) An uncommitted transaction commits automatically if the user exits sql*Plus

B) Data Manipulation Language (DML) statements always start a new transaction.

C) A user can always see uncomitted updates made by the same user in a dfferert session.

D) A Data Detiniton Language (DDL) statement does a commit automatially only for the data dictionary updates caused by the DDL

E) A session can always see uncomnitted updetes made by itselt.

F) If a session has an uncometted transaction,then a DDL statement issue a COMMIT before starting a new transaction.

Answer：AE

(解析：这道题考的是事务提交和没有提交时的状态，属于常规的理论知识。)