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
- 187602 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 are the disadvantages of views in a database?
A lowest level of security by most RDBMS is
What advantages does DBMS have over traditional file systems?
Explain artificial key?
What are the various ways to execute a query in teradata?
What do you mean by cluster and non cluster index?
Explain natural key?
Explain partial key?
List some advantages of dbms.
How do I setup a database connection?
aht is the difference b/w network & hierarchial & relational dbms????
What is a database example?
Write a query to get maximum and second maximum in oracle?
Difference between sql and mysql?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
