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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Difference between primary key and unique key ?

Question Posted / mudigouda patil

Answer Posted / mudigouda patil

PRIMARY KEY
1)TABLE CAN NOT HAVE MORE THAN ONE PRIMARY KEY.
2)PK DOES NOT ALLOW NULL VALUES.
UNIQUE KEY
1)TABLES CAN HAVE MORE THAN ONE UNIQUE KEY.
2)UNIQUE KEY ALLOWS NULL VALUES.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain compound trigger in oracle?

993

What is an anonymous block?

1155

How to call a stored function in oracle?

950

What is index in Oracle?

1009

What is a cursor in oracle?

1106

What are the different types of modules in oracle forms?

951

What operating systems are supported by oracle database 10g xe?

983

How to rollback the current transaction in oracle?

983

How many types of auditing in Oracle?

980

How to define a variable of a specific record type?

1017

How to select an oracle system id (sid)?

1018

Use of an integrity constraint is better to validate data. Explain

974

Explain what are synonyms used for?

980

What is oracle analytical function?

1029

What is materialized view in Oracle?

1042