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
- 185872 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
Can a database table exist without a primary key?
Is hive a database?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
How to do Data size testing? Who does this testing (Developer or tester)?
define primary key index, bitmap index, hash index,virtual indwx
Difference between sql and mysql?
What is the difference between primary key, foreign key and candidate key?
Does facebook use graph database?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What are different types of joins used in?
What is the purpose of firebase?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
Explain phantom deadlock?
What do you mean by cluster and non cluster index?
