Zend
200-710 · Question #159
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.
Databases & SQL
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
(24 responses)- A75% (18)
- C8% (2)
- D17% (4)
Topics
#transactions#affected rows#rollback#query results
Community Discussion
No community discussion yet for this question.