Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the difference between rollback & commit?
can a foreign key has null value?

Answer Posted / komal

Roll back Undoes whatever add, delete update transactions
we do.
Commit saves the add,delete update transactions
permanenetly in the database.

However a DML statement if fired in between a transaction
commits the complete list of add, delete update statements
above.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2784


definition of cluster and non-clustered index?

2984


How to create a table interactively?

1024


How do we represent comments in oracle?

1012


What is where clause in oracle?

998


How to build data dictionary view an new database?

975


How to define default values for formal parameters?

1002


How does oracle handle read consistency?

1065


What is parameterized cursor in oracle?

1085


What are the execution control statements?

1029


What are the common oracle dba tasks?

1091


What is raw datatype in oracle?

1081


How remove data files before opening a database?

1027


Explain compound trigger in oracle?

998


What is an oracle database table?

973