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 primary key & unique index ?

Answer Posted / mani

Primary key can be defined only one for a table whereas
number of unique indexes can be defined for a table.

primary key can not have null values but unique can have
null values and to remind one null value can never be equal
to another null value.

Is This Answer Correct ?    23 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is concurrency?

1304


What is access path in db2?

1042


How do I connect my db2 database to ibm?

1085


Explain about mirror activator disk mirroring?

1063


How will you return the number of records in table?

986


Which are the db2 tools to protect integrity of the database?

1166


What is the difference between cursor stability and repeatable read isolation levels?

1238


Is the primary key a clustered index?

1202


Is db2 a mainframe?

1096


Can you use max on a char column?

1141


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1216


Which component is used to execute the sql statements?

1145


What is cloudant database?

1158


Explain about cursor stability?

1109


How do I import data from excel to db2?

1128