Oracle
1Z0-071 · Question #289
In which three situations does a new transaction always start? (Choose three.)
The correct answer is D. when issuing the first Data Manipulation Language (DML) statement after a COMMIT or E. when issuing a DML statement after a DML statement failed in the same session F. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT. https://docs.oracle.com/cd/B19306_01/server.102/b14220/transact.htm
Manipulating Data
Question
In which three situations does a new transaction always start? (Choose three.)
Options
- Awhen issuing a TRUNCATE statement after a SELECT statement was issued in the same
- Bwhen issuing a CREATE INDEX statement after a CREATE TABLE statement completed
- Cwhen issuing a CREATE TABLE statement after a SELECT statement was issued in the same
- Dwhen issuing the first Data Manipulation Language (DML) statement after a COMMIT or
- Ewhen issuing a DML statement after a DML statement failed in the same session
- Fwhen issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT
How the community answered
(33 responses)- A15% (5)
- B3% (1)
- C6% (2)
- D76% (25)
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14220/transact.htm
Topics
#transactions#DML#DDL#COMMIT
Community Discussion
No community discussion yet for this question.