nerdexam
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)

Sign in or unlock 200-710 to reveal the answer and full explanation for question #159. The question stem and answer options stay visible for context.

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

Unlock 200-710 to see the answer

You've previewed enough free 200-710 questions. Unlock 200-710 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#transactions#affected rows#rollback#query results
Full 200-710 Practice