In Oracle Database 12c, when does a transaction begin?

The correct answer is D. when the first executable SQL statement is encountered. A transaction begins when the first executable SQL is encountered. An executable SQL statement is a SQL statement that generates call to a database instance, including DML and DDL statements and the SET TRANSACTION statement.

Oracle Database 12c Architecture

Question

Options

Awhen a transaction ID is allocated for it.
Bwhen a user explicitly issues a "begin" statement
Cwhen a transaction is assigned to an available undo data segment to record undo entries for the
Dwhen the first executable SQL statement is encountered

How the community answered

(24 responses)

A
17% (4)
B
4% (1)
C
8% (2)
D
71% (17)

Explanation

A transaction begins when the first executable SQL is encountered. An executable SQL statement is a SQL statement that generates call to a database instance, including DML and DDL statements and the SET TRANSACTION statement.

Topics

#transaction lifecycle#undo segments#SQL execution#transaction management

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice