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

Difference between primary key and unique key ?

Answer Posted / dinesh

Primary Key:
It wont accept NULL values.
It wont accept Duplication.
Unique Key:
It accepts NULL values.
Foreign Key:
It accepts NULL values.
It accepts Duplication.
Main point is, A Foreign key denotes a Primary key in the another table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use fetch statement in a loop?

971


What happens if recursive calls get out of control?

998


What are a collation and state the different types of collation sensitivity?

1092


How to use "startup" command to start default instance?

962


How to unlock the sample user account in oracle?

916


How would you begin to troubleshoot an ORA-3113 error?

2023


How to update values on multiple rows in oracle?

972


How to create a server parameter file?

1080


What is an index associated with a constraint?

973


What do you understand by database schema and what does it hold?

1177


What are ddl statements in oracle?

1014


What is meant by recursive hints in oracle?

1026


How to create additional tablespaces for an new database?

968


Hi Can any one tell me what are the API's used in requisition import.

1879


Explain about your project and its relation to the current job position you are applying to?

943