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
- 187887 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / teju
PRIMARY KEY :
IN THE TABLE we can find only one record as
uniqely & also it is not null.
unique key:
uk is to search any record as uniquely& when it
is declared it should be only one null values.
Fk:
fk is to maintain the relations bet two tables
as an duplicate values.means to not null.
e.g
1> stud(stud_id,stud_name);
2> stud_det(stud_id,addr);
In this table stud_id is an pk & In the stud_det as
stud_id is used as an duplicate.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the concept of Virtual field?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
A design problem was given in which I was supposed to make a design for the data base for a given problem.
What is ole db used for?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
give a simple example of physical and logical data independence
What are different types of resources?
How does non-cluster index functions?
What is the role of tester in discovery(in Checklist)?
What are the advantages of views in a database?
How to produce such kind of file?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
Can we use redis as database?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
What is the difference between primary key, foreign key and candidate key?
