Interested to Buy Any Domain ? << Click Here >> for more details...
i want to know how the commit option works,how it save the
changes? it will update the database or what ? where we can
see these saved changes?
- 4 Answers
- 7417 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
All changes happens to database are initially made in log,
after successful completion of unit of work (COMMIT),the
changes from log reflected into physical database. In case
of roll-back or un-successful completion, changes will not
be reflested into physical database.
Commit executed at the end of all transaction (explicitly
or inplicitly) irrespective of number of rows affected.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How can the duplicate values be eliminated from db2 select?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the role of union all and union
Explain about rct.
What is check constraint in db2?
List down the types of triggers in the db2 database?
Why db2 is called db2?
What is a bind card?
What is db2 and what is the use of db2 optimizer?
What is the difference between bind and rebind in db2?
What are the 2 sqlcodes that are returned?
How do you find the maximum value in a column in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is blu acceleration in db2?
What is the use of db2?
