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…

Question

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

• A
  10% (3)
• B
  80% (24)
• C
  7% (2)
• D
  3% (1)

Explanation

In Oracle, DDL statements (like CREATE, DROP, ALTER) trigger an implicit commit - they automatically commit any pending transaction in the same session before executing, making B correct. Option E is correct because SHUTDOWN NORMAL waits for all connected sessions to disconnect gracefully; when the session terminates as part of this shutdown, Oracle commits the active transaction.

Why the distractors are wrong:

• A - DDL in a different session has no effect on transactions in your session; sessions are isolated.
• C & D - DML statements (INSERT, UPDATE, DELETE) never trigger implicit commits; they participate in the current transaction or start a new one, leaving any existing transaction open.

Memory tip: Think "DDL = Done, Done, Later" - DDL in your own session commits what came before it, then runs. For shutdown, remember that NORMAL is polite - it waits for you to finish and commits cleanly, unlike SHUTDOWN ABORT which would roll back.

No community discussion yet for this question.