Oracle Exam 1Z0-900 Topic 9 Question 67 Discussion

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

Question #: 67
Topic #: 9

[All 1Z0-900 Questions]

Given:

If an exception is thrown inside the if block, what effect will it have on the transaction?

AThe transaction will be committed.

BThe transaction will be suspended.

CThe transaction will be rolled back.

Show Suggested Answer

Suggested Answer: A

by Willow at Aug 31, 2023, 10:25 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Winfred

14 days ago

If an exception is thrown inside the if block, the transaction will be rolled back. This is the correct answer, as exceptions inside a transaction should cause the entire transaction to be rolled back to ensure data integrity.

upvoted 0 times

...

Serita

21 days ago

I'm not sure, but I think the transaction might be suspended if an exception is thrown inside the if block.

upvoted 0 times

...

Dorethea

24 days ago

I agree with Benedict, because if an exception occurs, the transaction should be rolled back to maintain data consistency.

upvoted 0 times

...

Benedict

26 days ago

I think if an exception is thrown inside the if block, the transaction will be rolled back.

upvoted 0 times

...