Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between commit and rollback.?
- 5 Answers
- 33645 Views
- Cognizant, Patni, I also Faced
- E-Mail Answers
Answer Posted / malli.gontla
suppose u have one table which is in database. The table
contains some records. U want to modify one record of table.
after modification, u don't want that new values for
the record. just u use rollback command. previous values are
placed in database.
Example:
Case 1: Roll Back
sno name palce
1 abc hyderabad
2 xyz bangalore.
This is the table and it contains some records.
Suppose if u want change the 2nd record, means palce
is changed to chennai.
After modification:
sno name palce
1 abc hyderabad
2 xyz Chennai.
Suppose if u want old values, means u don't want new
values. At that time u use roll back command
After useing rollback:
sno name palce
1 abc hyderabad
2 xyz bangalore.
after using roll back, the records are comes like
above(original records)
Case 2: Commit
sno name palce
1 abc hyderabad
2 xyz bangalore.
This is the table and it contains some records.
Suppose if u want change the 2nd record, means palce
is changed to chennai.
After modification:
sno name palce
1 abc hyderabad
2 xyz Chennai.
After useing commit:
sno name palce
1 abc hyderabad
2 xyz Chennai.
after using commit, the table is finilased.u can't get
old values by uisng roll back.
Once if u use commit,u can't get old values for using of
rollback. Before commit, u can get old values for rollback.
| Is This Answer Correct ? | 112 Yes | 4 No |
Post New Answer View All Answers
A field-groups statement or an insert statement reverses storage space and transfers values. State true or false. : abap modularization
What is append search help? : sap abap data dictionary
HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)
What are the main uses of the primary key?
What is the diff between database view and maintenance view?
Explain what is the difference between primary key and unique key?
What is the difference between internal tables and extract datasets? : abap modularization
What is repository info. Systems?
What are the problems in processing batch input sessions? How is batch inputprocess different from processing online?
What is view proxy in abap?
What are Table control and tab strip control in dialog programming ?
What are the different types of the sap abap data dictionary objects?
What is an update type with reference to a match code id? : abap data dictionary
Explain the difference between a pool table and a transparent table and how they are stored at the database level?
How to debug rfc function module?
