Which two are true about transactions in the Oracle Database?
A.
DDL statements automatically commit only data dictionary updates caused by executing the DDL.
B.
A DDL statement issued by a session with an uncommitted transation automaticall commits that transaction.
C.
An uncommitted transaction is automatically committed when the user exits SQL*PLUS
D.
DML statements always start new transactions.
E.
A session can see uncommitted updates made by the same user in a different session
The Answer Is:
B, D
This question includes an explanation.
Explanation:
B. True. DDL (Data Definition Language) statements in Oracle Database are auto-commit statements. This means that if a DDL statement is issued, any uncommitted transactions in the same session will automatically be committed.
D. False. This is a common misconception. DML (Data Manipulation Language) statements do not automatically start new transactions. In Oracle, a transaction begins when the first DML statement (INSERT, UPDATE, DELETE, MERGE, SELECT FOR UPDATE) is encountered after a previous transaction has been committed or rolled back.
A is incorrect because DDL statements automatically commit the entire transaction, not just the data dictionary updates. C is incorrect because an uncommitted transaction is not automatically committed when a user exits SQL*Plus; instead, it is rolled back. E is incorrect because a session cannot see uncommitted updates made by other sessions.
[Reference: Oracle Database SQL Language Reference 12c, Transaction Control - COMMIT, , ]
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"