Oracle
1Z0-873 · Question #137
Some statements implicitly commit pending transactions and start a new one.
The correct answer is A. True. If you issue any of the following statements, InnoDB implicitly commits the preceding uncommitted statements of the current transaction and begins a new transaction: SET AUTOCOMMIT = 1 START TRANSACTION
Transactions and Locking
Question
Some statements implicitly commit pending transactions and start a new one.
Options
- ATrue
- BFalse
How the community answered
(32 responses)- A75% (24)
- B25% (8)
Explanation
If you issue any of the following statements, InnoDB implicitly commits the preceding uncommitted statements of the current transaction and begins a new transaction: SET AUTOCOMMIT = 1 START TRANSACTION
Topics
#implicit commit#DDL statements#transaction boundaries#autocommit
Community Discussion
No community discussion yet for this question.