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

Commit made changes permenant to the database.
Rollback made undo the changes.

Yes, FK has null values.

Is This Answer Correct ?    23 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain an extent?

1094


Explain table?

1105


Explain what are the different type of segments?

958


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2015


How to retrieve values from data fields in record variables?

1109


Why does Oracle not permit the use of PCTUSED with indexes?

2417


What is the use of aggregate functions in oracle?

1023


Explain implicit cursor.

1020


How to start a new transaction in oracle?

1081


Explain an exception?

990


What is an oracle user account?

984


Explain compound trigger in oracle?

1029


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1345


What are operators in oracle?

1053


is there a tool to trace queries, like profiler for sql server?

1139