Oracle
1Z0-873 · Question #135
Which of the following happens when BEGIN TRANSACTION or START TRANSACTION command is issued?
The correct answer is C. Autocommit mode is suspended until COMMIT. See the full explanation below for the reasoning.
Question
Which of the following happens when BEGIN TRANSACTION or START TRANSACTION command is issued?
Options
- AAutocommit mode overrides BEGIN TRANSACTION and START TRANSACTION.
- BAutocommit mode is suspended and has to be re-enabled explicitly.
- CAutocommit mode is suspended until COMMIT.
- DNothing happens as they are not valid commands.
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C85% (22)
- D8% (2)
Community Discussion
No community discussion yet for this question.