Oracle Exam 1Z0-909 Topic 12 Question 22 Discussion

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

Question #: 22
Topic #: 12

[All 1Z0-909 Questions]

Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2:

Now, examine this statement that execute successfully in s1:

S1> SELECT * FROM emp;

Which is true about the result of the select statement?

AThe inserted row is returned because the transaction is auto committed in S2.

BThe inserted row is not returned because the isolation level is READ COMMITTED in S2.

CThe inserted row is not returned because the transaction still active in s2.

DThe inserted row is returned because the isolation level is RPEATABLE READ in S1.

Show Suggested Answer

Suggested Answer: C

by Pamella at Jul 24, 2023, 06:46 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Michell

2 months ago

I'm just hoping the next question isn't about deadlocks. That's when I usually end up in a deadlock with the exam itself.

upvoted 0 times

William

17 days ago

C) The inserted row is returned because the isolation level is RPEATABLE READ in S1.

upvoted 0 times

...

William

1 months ago

B) The inserted row is not returned because the transaction still active in s2.

upvoted 0 times

...

Dana

1 months ago

A) The inserted row is not returned because the isolation level is READ COMMITTED in S2.

upvoted 0 times

...

Hannah

2 months ago

But doesn't the auto commit in S2 affect the result?

upvoted 0 times

...

Julio

2 months ago

I disagree, I believe the correct answer is D.

upvoted 0 times

...

Hannah

2 months ago

I think the answer is B.

upvoted 0 times

...

Giovanna

2 months ago

Wow, these SQL questions are getting more and more convoluted. At this rate, they'll be asking us to debug the entire database server next!

upvoted 0 times

Nan

28 days ago

I agree, it's like they want us to be SQL experts or something.

upvoted 0 times

...

Tamekia

2 months ago

I know right, these questions are getting really complex.

upvoted 0 times

...

Fausto

2 months ago

But doesn't the transaction being active in S2 affect the result?

upvoted 0 times

...

Omer

2 months ago

Haha, I bet the exam writer tried to trick us with all those different isolation levels. But I'm not falling for it, Option C is the way to go!

upvoted 0 times

...

Eura

2 months ago

I disagree, I believe the correct answer is D.

upvoted 0 times

...

Ciara

2 months ago

I'm not sure why they're asking about isolation levels when the question is clearly focused on transaction control. Option C makes the most sense to me.

upvoted 0 times

...

Glynda

2 months ago

Option C is the correct answer. The transaction is still active in S2, so the inserted row is not yet visible in the SELECT statement in S1.

upvoted 0 times

...

Fausto

2 months ago

I think the answer is B.

upvoted 0 times

...