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.
Bạn đang xem 2. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P41 POTX