Given the code in the exhibit, what will be the state of the database if the procedure st_update succeeds and st_insert fails?

Click the <<ItemExhibitName>> button to view the exhibit.

Given the code in the exhibit, what will be the state of the database if the procedure st_update succeeds and st_insert fails?
A . It depends on the ANSI MODE state of the database.
B . The changes made by st_update and st_insert are not reflected.
C . The changes made by st_insert will be in place, but not those of st_update.
D . The changes made by st_update will be in place, but not those of st_insert.

View Answer

Answer: B