what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 179775 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 types of joins?
Differentiate between unique key and foreign key?
What is the candidate key used for?
What is ole db in ssis?
Under which circumstance should you create an index on a table?
What is a trace file?
sparse lookup and where its options we find in OCI and db2?
what is rcp,if rcp disabled what happen?
give a simple example of physical and logical data independence
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What is the importance of database partitioning?
How concurrency problems effect the database?
What is difference between server and database?
