Oracle Exam 1Z0-082 Topic 7 Question 101 Discussion

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

Question #: 101
Topic #: 7

[All 1Z0-082 Questions]

An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table.

Which three situations does the transaction complete thereby committing the updates?

Awhen a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

Bwhen a CREATE INDEX statement is executed successfully in the same session

Cwhen a COMMIT statement is issued by the same user from another session in the same database instance

Dwhen the session logs out successfully

Ewhen a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

Fwhen a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

Show Suggested Answer

Suggested Answer: A

by Ora at Sep 06, 2024, 10:28 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

Option A and E seem correct, but I'm not sure about the others. Better double-check the Oracle documentation to be certain.

upvoted 0 times

...

15 days ago

I'm not sure about the other options, but I think option C is the most reliable way to commit the updates in this scenario.

upvoted 0 times

...

16 days ago

I agree with Denise. That option makes sense because it ensures the updates are committed before the transaction is completed.

upvoted 0 times

...

18 days ago

I think the transaction completes when a COMMIT statement is issued by the same user from another session in the same database instance.

upvoted 0 times

...