Oracle Exam 1Z0-497 Topic 1 Question 93 Discussion

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

Question #: 93
Topic #: 1

[All 1Z0-497 Questions]

In Oracle Database 12c, when does a transaction begin?

Awhen a transaction ID is allocated for it.

Bwhen a user explicitly issues a 'begin' statement

Cwhen a transaction is assigned to an available undo data segment to record undo entries for the new transaction

Dwhen the first executable SQL statement is encountered

Show Suggested Answer

Suggested Answer: D

https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

by Kanisha at May 23, 2024, 05:35 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Aleisha

6 months ago

As a database newbie, I'm just hoping I can spell 'Oracle' correctly on the exam.

upvoted 0 times

...

Krissy

6 months ago

Haha, this question is a real head-scratcher. I'll just guess and hope for the best!

upvoted 0 times

...

Laurena

7 months ago

Hmm, I'm not sure. Maybe C? The transaction is assigned to an undo data segment to record undo entries.

upvoted 0 times

Desmond

5 months ago

I agree with you. It's definitely D.

upvoted 0 times

...

Stefany

5 months ago

I think it's D. The transaction begins when the first executable SQL statement is encountered.

upvoted 0 times

...

Caitlin

6 months ago

I'm not sure, maybe C? The transaction is assigned to an undo data segment to record undo entries.

upvoted 0 times

...

Trina

6 months ago

I think it's when a transaction ID is allocated for it.

upvoted 0 times

...

Eladia

7 months ago

B sounds right to me. The transaction starts when the user explicitly issues a 'begin' statement.

upvoted 0 times

Paris

6 months ago

No, it actually begins when the first executable SQL statement is encountered.

upvoted 0 times

...

Pearlie

6 months ago

I think it's when a transaction ID is allocated for it.

upvoted 0 times

...

Sharan

7 months ago

I think it's option D. The transaction begins when the first executable SQL statement is encountered.

upvoted 0 times

Adela

6 months ago

Good to know, thanks for clarifying that!

upvoted 0 times

...

Kanisha

6 months ago

Exactly, it's all about when the SQL statements start running.

upvoted 0 times

...

Melvin

6 months ago

Yes, that's correct. It's not just when a transaction ID is allocated or when a 'begin' statement is issued.

upvoted 0 times

...

Hollis

6 months ago

What happens when a transaction is committed in Oracle Database 12c?

upvoted 0 times

...

Johna

6 months ago

That makes sense, so the transaction doesn't actually start until a SQL statement is executed.

upvoted 0 times

...

Kassandra

7 months ago

In Oracle Database 12c, what is the purpose of undo data segments?

upvoted 0 times

...

Cecily

7 months ago

I agree, the transaction begins when the first executable SQL statement is encountered.

upvoted 0 times

...

Rolf

7 months ago

I think it's option D.

upvoted 0 times

...