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 and unique key

Answers were Sorted based on User's Feedback



What is the difference between primary and unique key..

Answer / venkat rao

Unique key takes null value but primary key doesnot take
null value
primary key have properties of both null key and unique key
constraints

Is This Answer Correct ?    21 Yes 4 No

What is the difference between primary and unique key..

Answer / sudhanshu_kmr

.....primary key.......... unique key

at most one column .....:... any number of column

only unique values........... only unique values

don't accept null........... accept null

Is This Answer Correct ?    3 Yes 2 No

What is the difference between primary and unique key..

Answer / ashish asthana

Primay key restrict the duplicacy in the records and does
not accept null value or there are only one primary key in
a table

Unique constraint also restict the duplicacy but it accept
the null value one or more then one. We can apply unique
constraint more than one column

Is This Answer Correct ?    2 Yes 2 No

What is the difference between primary and unique key..

Answer / durai

primary key is does not allow duplicate which is contain not
null it is only once we can use in table

unique key allow null value

Is This Answer Correct ?    0 Yes 0 No

What is the difference between primary and unique key..

Answer / pradeep rajpoot

primary key no null value allow.
but unique key one null value is allow

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More MySQL Interview Questions

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,


What is username in mysql?

0 Answers  


What is the use of mysqli_query?

0 Answers  


What is heap table?

0 Answers  


how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

0 Answers  


What is memory table?

0 Answers  


Is mysql still relevant?

0 Answers  


What is pdo in php mysql?

0 Answers  


How to run a sql statement?

0 Answers  


Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

0 Answers  


How important is to list the column names when doing an insert?

0 Answers  


How do I install mysql on windows 7?

0 Answers  


Categories