nerdexam
Zend

200-550 · Question #137

When a query that is supposed to affect rows is executed as part of a transaction, and reports no affected rows, it could mean that: (Choose 2)

The correct answer is A. The transaction failed B. The transaction affected no lines. See the full explanation below for the reasoning.

Question

When a query that is supposed to affect rows is executed as part of a transaction, and reports no affected rows, it could mean that: (Choose 2)

Options

  • AThe transaction failed
  • BThe transaction affected no lines
  • CThe transaction was rolled back
  • DThe transaction was committed without error

How the community answered

(26 responses)
  • A
    77% (20)
  • C
    8% (2)
  • D
    15% (4)

Community Discussion

No community discussion yet for this question.

Full 200-550 Practice