Oracle
1Z0-082 · Question #80
In which three situations does a new transaction always start? (Choose three.)
The correct answer is A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT D. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR F. when issuing a DML statement after a DML statement failed in the same session. See the full explanation below for the reasoning.
Manage Data Concurrency
Question
In which three situations does a new transaction always start? (Choose three.)
Options
- Awhen issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT
- Bwhen issuing a TRUNCATE statement after a SELECT statement was issued in the same
- 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 CREATE INDEX statement after a CREATE TABLE statement completed
- Fwhen issuing a DML statement after a DML statement failed in the same session
How the community answered
(35 responses)- A71% (25)
- B6% (2)
- C14% (5)
- E9% (3)
Topics
#transaction management#DML#DDL auto-commit#COMMIT
Community Discussion
No community discussion yet for this question.