Oracle Exam 1Z0-149 Topic 1 Question 39 Discussion

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

Question #: 39
Topic #: 1

[All 1Z0-149 Questions]

Examine these statements:

Which two are true? (Choose two.)

ANeither table will have a row inserted and committed.

BBoth tables will have a row inserted and committed.

CThe transaction for the bank_activity_proc is independent of the bank_transaction_proc.

DThe bank_activity_proc will not compile because of the commit.

EOnly one table will have a row inserted and committed.

Show Suggested Answer

Suggested Answer: C, D

by Isadora at Sep 14, 2024, 03:17 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jerilyn

1 months ago

Haha, can you imagine if the proc didn't compile because of a commit? That's a good one. Anyway, I think B and C are the way to go here. Gotta love these tricky database questions.

upvoted 0 times

Tambra

3 days ago

Definitely, it's always interesting to see how transactions work in databases.

upvoted 0 times

...

Shaniqua

5 days ago

Yeah, those statements make the most sense in this scenario.

upvoted 0 times

...

Cletus

21 days ago

I agree, B and C seem like the correct choices.

upvoted 0 times

...

Val

1 months ago

Oof, these database questions can be a real headache. I'm just going to guess B and E and hope for the best. At least I won't be the one who says the proc won't compile because of a commit!

upvoted 0 times

Reuben

4 days ago

User1: Let's go with B and E then. Fingers crossed!

upvoted 0 times

...

Jesusita

6 days ago

User2: Yeah, I agree. Those seem like the most likely options.

upvoted 0 times

...

Katlyn

1 months ago

User1: I think B and E are correct.

upvoted 0 times

...

Albert

2 months ago

Ha! D is a classic trick answer. Like the commit would make the proc not compile? That's just silly. I'm going with B and C.

upvoted 0 times

Aretha

15 days ago

Definitely, B and C are the most logical options here.

upvoted 0 times

...

Chauncey

17 days ago

Yeah, D just seems like a distraction. B and C seem like the correct choices.

upvoted 0 times

...

Miesha

1 months ago

I agree, D does seem like a trick answer. I think B and C make more sense.

upvoted 0 times

...

Sheridan

2 months ago

I'm not so sure about C. The question says the transactions are independent, but I'm not convinced that means the procedures themselves are independent. I'm leaning towards B and E.

upvoted 0 times

Royal

7 days ago

I see your point, but I still think C is the correct answer here.

upvoted 0 times

...

Miles

19 days ago

I'm not so sure about C either, I think B and E make more sense in this context.

upvoted 0 times

...

Josphine

26 days ago

I agree with you, C seems to be the correct choice based on the information provided.

upvoted 0 times

...

Hubert

1 months ago

I think C is true because the question specifically mentions that the transactions are independent.

upvoted 0 times

...

Cordie

2 months ago

But doesn't the commit in option D affect the bank_activity_proc?

upvoted 0 times

...

Lizbeth

2 months ago

Hmm, this one's tricky. I think B and C are the correct answers here. The two procedures seem to be independent, and both should commit their changes.

upvoted 0 times