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 actual and formal parameters?

1159


What is oracle and what are its different editions?

1118


What are the different types of trigger and explain its various uses and functions?

1164


Will you be able to store pictures in the database?

1169


Can we protect our pl/sql source code?

1078


What are the differences between char and nchar in oracle?

1135


How to open and close an explicit cursor in oracle?

1093


Explain the truncate in oracle?

1009


What is the maximum number of triggers that can be applied to a single table?

1065


 What are the oracle DML commands possible through an update strategy?

1101


What is columnar storage what is the advantage?

1119


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2038


What is oracle server autotrace in oracle?

1218


How to execute a stored procedure in oracle?

1141


What is snapshot is too old? Give and example for better understand.

1649