【2019年8月】OCP 071認證考試最新版本的考試原題-第23題

• 2019 年 11 月 6 日
• 筆記

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

(解析：這道題考的是事務提交和沒有提交時的狀態，屬於常規的理論知識。)