5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- What are the min.extents allocated to a rollback extent ?
- What are the min.extents allocated to a rollback extent?
- Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the ...
- If you have committed several transactions and have several more transactions that have not been committed ...
- The state after a transaction has been rolled back and the database has been restored to its state prior to...
- For bulk insert, inserted rows are buffered and sent to the database server
- A Transaction ends
- A Transaction ends