IBM
C2090-558 · Question #2
Which two statements are true about the COMMIT WORK statement? (Choose two.)
The correct answer is A. The keyword WORK is optional. D. All of the successful modifications that the transaction makes are saved to disk when you issue a. See the full explanation below for the reasoning.
Question
Which two statements are true about the COMMIT WORK statement? (Choose two.)
Options
- AThe keyword WORK is optional.
- BA single COMMIT WORK can end several BEGIN WORK statements.
- CThe COMMIT WORK statement releases all row locks but not table locks.
- DAll of the successful modifications that the transaction makes are saved to disk when you issue a
- EA new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK
How the community answered
(18 responses)- A83% (15)
- B11% (2)
- C6% (1)
Community Discussion
No community discussion yet for this question.