Posted by: Pdfprep
Post Date: November 30, 2020
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
Answer: C
Leave a Reply