Oracle 1Z0-071 Exam - Topic 1 Question 120 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 120
Topic #: 1

[All 1Z0-071 Questions]

Which two are true about transactions in the Oracle Database?

AA session can see uncommitted updates made by the same user in a different session.

BA DDL statement issued by a session with an uncommitted transaction automatically Commits that transaction.

CDML statements always start new transactions.

DDDL statements automatically commit only data dictionary updates caused by executing the DDL.

EAn uncommitted transaction is automatically committed when the user exits SQL*Plus.

Show Suggested Answer

Suggested Answer: B, E

This question appears to be a duplicate of question no. 269, and the correct answers provided there apply here as well.

B . True. A DDL statement automatically commits any outstanding uncommitted transaction in the session. E. True. Exiting SQL*Plus without explicitly committing a transaction will cause the uncommitted transaction to be rolled back, not committed.

A, C, and D are incorrect for the same reasons provided in the explanation for question no. 269.

by Ruthann at Jul 31, 2025, 07:24 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lavonda

3 months ago

Wait, E? Really? That sounds surprising!

upvoted 0 times

...

Georgeanna

3 months ago

B is definitely correct, DDL auto-commits.

upvoted 0 times

...

Lorrie

3 months ago

D is true, DDL does commit data dictionary updates.

upvoted 0 times

...

Gracia

4 months ago

I thought A was true, but I guess not!

upvoted 0 times

...

Pearlene

4 months ago

C seems off, DML doesn't always start a new transaction.

upvoted 0 times

...

Catrice

4 months ago

I have a vague memory that option E is incorrect because uncommitted transactions usually stay uncommitted unless explicitly committed.

upvoted 0 times

...

Lavonne

4 months ago

I recall practicing a question similar to this, and I think D is correct since DDL does commit changes to the data dictionary.

upvoted 0 times

...

Lamar

5 months ago

I'm not entirely sure about option A; I feel like we might have covered something about session visibility, but I can't remember the details.

upvoted 0 times

...

Amie

5 months ago

I think option B sounds familiar because we discussed how DDL statements behave differently from DML in class.

upvoted 0 times

...

Gene

5 months ago

Hmm, this is a tricky one. I'll need to carefully read through each option and think about how transactions work in Oracle. Gotta make sure I don't miss any nuances.

upvoted 0 times

...

Pamella

5 months ago

I'm a bit confused about the difference between a session seeing its own uncommitted updates versus a DDL statement automatically committing the current transaction. I'll need to double-check those details.

upvoted 0 times

...

Gwenn

5 months ago

I've got this! Transactions are one of my strong suits. I'm pretty confident I can identify the two correct statements here.

upvoted 0 times

...

Maurine

5 months ago

Okay, let me see here. I remember learning about how DDL statements can automatically commit the current transaction, but I'm not sure about the specifics. I'll have to review my notes on that.

upvoted 0 times

...

Jess

6 months ago

Hmm, this question seems to cover some key concepts about transactions in Oracle. I'll need to think carefully about the differences between DML and DDL statements and how they impact transactions.

upvoted 0 times

...