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

Albert

2 days 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

...

Sheridan

9 days 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

...

Cordie

15 days ago

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

upvoted 0 times

...

25 days ago

I think the correct answers are A and C.

upvoted 0 times

...