Microsoft
MB7-702 · Question #98
You have heard that the COMMIT statement must be used sparingly in C/SIDE. Why?
The correct answer is B. If it is used in the middle of a transaction and an error condition occurs after the COMMIT. See the full explanation below for the reasoning.
Question
You have heard that the COMMIT statement must be used sparingly in C/SIDE. Why?
Options
- ATo regulate the size of the database.
- BIf it is used in the middle of a transaction and an error condition occurs after the COMMIT
- CTo minimize validation errors during posting.
- DThis command will stop processing and roll back the current transaction in case of an error.
How the community answered
(30 responses)- A13% (4)
- B77% (23)
- C3% (1)
- D7% (2)
Community Discussion
No community discussion yet for this question.