nerdexam
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)
  • A
    13% (4)
  • B
    77% (23)
  • C
    3% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full MB7-702 Practice