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 are group functions in oracle?

985


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2071


How do I use os authentication with weblogic jdriver for oracle and connection pools?

1004


How many file formats are supported to export data?

1145


What is an oracle cursor variable?

1019


How index is implemented in oracle database?

951


Explain the difference between a procedure and a function? What do you understand by those terms?

1028


Which is better Oracle or MS SQL? Why?

4837


What are the built-in functions used for sending Parameters to forms ?

3319


What is BBED in Oracle?

1096


What are the different editions of oracle?

1058


When do you get a .pll extension in oracle?

1084


What is ordinary table in oracle?

1082


What are the differences between number and binary_float in oracle?

1062


What is set operator oracle?

930