Exam 1Z0-082 Topic 2 Question 51 Discussion

Actual exam question for Oracle's 1Z0-082 exam
Question #: 51
Topic #: 2

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?

A. when a COMMIT statement is issued by the same user from another session in the same database instance B. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT C. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT D. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session E. when a CREATE INDEX statement is executed successfully in the same session F. when the session logs out successfully

Comments

noura

2026-08-24 14:15:37

Selected Answer: DEF

upvoted 1 times

...

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business