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 / ashu_deepu

rollback is used to revert back the changes which we have made in the databases.when we do the rollback we return back to the last commit point which we have made.

commit is use to make the changes in the databases permanently. the values of the variables are written to the databases or disk.

FK can have null value but primary key can't have null value.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens if the update subquery returns multiple rows?

1037


What is system tablespace?

1039


How to define an anonymous procedure with variables?

1057


What are the common oracle dba tasks?

1068


What are oracle functions?

971


What is a read only transaction in oracle?

969


How to load data from external tables to regular tables?

982


What is java oracle used for?

961


Can we protect our pl/sql source code?

991


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2069


How to write a query with a left outer join in oracle?

998


Explain the difference between a procedure and a function?

1082


How to speed up webrick?

1004


How can we view last record added to a table?

968


How to create a testing table in oracle?

944