Oracle
1Z0-083 · Question #57
1Z0-083 Question #57: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #57. The question stem and answer options stay visible for context.
Oracle Database Architecture
Question
An Oracle Database server session has an uncommitted transaction in progress which updated 5000 rows in one table. In which two situations does the transaction complete, thereby committing the updates?
Options
- AWhen a DDL statement is executed successfully by same user in a different session.
- BWhen a DDL statement is executed successfully by the user in the same session.
- CWhen a DML statement is executed successfully by same user in a different session.
- DWhen a DML statement is executed successfully by the user in the same session.
- EWhen a DBA issues a successful SHUTDOWN NORMAL statement and the session terminates
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Transaction Control#DDL Auto-Commit#Session Management#Implicit Commits