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 a system tablespace and when it is created?

918

How to list all tables in your schema?

990

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2052

How to convert a date to char in oracle? Give one example.

1001

What is sharded cluster?

924

What privilege is needed for a user to insert rows to tables in another schema?

955

Explain do view contain data?

940

What are the system predefined user roles?

982

What is Java Pool in Oracle?

1090

How to use "in out" parameter properly?

998

What are the different oracle database objects?

1030

How to increment dates by 1 in oracle?

990

What is SQL access advisor in Oracle?

1136

How to create an oracle testing table?

1006

How many types of tables supported by oracle?

1018