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
- 187698 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 are the advantages of views in a database?
Explain entity set?
How do database connections work?
Explain inner and outer joins with examples.
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
Which three commands cause a transaction to end?
What are different types of joins used in?
What is a Database?
Explain partial key?
How many indexes can be created on a table?
What is ole db used for?
What are the advantages of using database?
how do you do sql tuning?
How to do Data size testing? Who does this testing (Developer or tester)?
Why do we need distributed database?
