Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 186353 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / doraswamy
One table allows only one primary key but there is no
restriction for unique keys.
These two are same but one difference is unique key will
allow nulls.
Primary key create on a combination of mulitiple colums.
Foreign key is reference of another table primiary key. It
will not allow null values.
~Doraswamy
| Is This Answer Correct ? | 106 Yes | 43 No |
Post New Answer View All Answers
What is difference between data and database?
What happens when shared and exclusive locks are applied on data item?
What is a driver in database?
How is image stored in database?
Which is the best graph database?
What is the difference between a stored procedure and a query?
how can you perform lookup range in lookup stage expalin in detail?
Differentiate between extension & intension?
What is the difference between specialization and generalization?
What is database and its types?
Can a database table exist without a primary key?
What is the candidate key used for?
What are different types of clusters present?
What is the advantage of varchar2 over char?
Explain alternate key?
