IF AN UPDATE OR DELETE COMMAND HAS A WHERE CLAUSE THAT GIVES IT A S...

2. If an UPDATE or DELETE command has a WHERE clause that gives it a

scope of several rows, what will happen if there is an error partway through

execution? The command is one of several in a multistatement transaction.

(Choose the best answer.)

A. The command will skip the row that caused the error and continue.

B. The command will stop at the error, and the rows that have been updated

or deleted will remain updated or deleted.

C. Whatever work the command had done before hitting the error will be

rolled back, but work done already by the transaction will remain.

D. The whole transaction will be rolled back.