IBM
C2090-320 · Question #58
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…
The correct answer is C. 30. See the full explanation below for the reasoning.
Question
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?
Options
- A10
- B20
- C30
- DAn -880 SQLCODE will be issued when the statement is executed
How the community answered
(25 responses)- A16% (4)
- B4% (1)
- C72% (18)
- D8% (2)
Community Discussion
No community discussion yet for this question.