Explain transactions, commits and rollbacks in DB2.
Answer Posted / kumar
Transaction is any basic operation in DB2 like Insert,
Update, Delete is called transaction.
Commit: Make the changes permanently in database
Rollback: Get back the changes to the database.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the uses of db2 optimizer?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is dclgen (declaration generator)?
What is catalog database in db2?
What are the full forms of spufi and dclgen and why are they used?
Why select is not preferred in embedded sql programs?
What is innodb buffer pool?
Is db2 a mainframe?
How would the varchar column remarks defined?
How and when does the db2 enforces the unique key?
List out the three types of page locks that can be held.
What is schema in db2?
What is database alias db2?
What is ibm db2 client?
What is iseries database?