What will be the value in COL1 of the SCHEMA.TABLE?

Given the following sequence of events:

1) COL1 in SCHEMA.TABLE has a value of 10

2)Update COL1 in SCHEMA.TABLE to 20

3) Set SAVEPOINT A

4) Update COL1 in SCHEMA.TABLE to 30

5) Set SAVEPOINT B

After issuing the statement: ROLLBACK TO SAVEPOINT

What will be the value in COL1 of the SCHEMA.TABLE?

A. 10

B. 20

C. 30

D. An -880 SQLCODE will be issued when the statement is executed

View Answer

Answer: C