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

Answer Posted / kundn

Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns

Is This Answer Correct ?    14 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sharded cluster?

1015

How to run the anonymous block again?

1132

Explain about integrity constraint?

1124

What is rich query?

983

What is blob data type in oracle?

1123

What are a query and state the different types of queries and their uses?

1016

How to define and use table alias names in oracle?

943

What are the restrictions on external table columns?

1054

How to invoke the original export import utilities?

1064

Explain the use of consistent option in exp command.

1068

what is normalisation?what are its uses?

2273

Is it possible to split the print reviewer into more than one region ?

2280

Explain the use of show option in imp command.

1098

How to unlock the sample user account in oracle?

1018

How to write date and time interval literals in oracle?

1036