what is primary key,unique key, foreign key? can u teach me
in simple language?

Answer Posted / kavita ahuja

primary key is an attribute or set of attribute of a table
that uniquely identified each record whereas foreign key is
the attribute that is used to create relation between two
tables.and the values for foreign key must match with the
values of primary key to which it refers.

Is This Answer Correct ?    21 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is data access layer?

1974


how node connect with cpu?

1660


Difference between sql and mysql?

1624


A design problem was given in which I was supposed to make a design for the data base for a given problem.

561


What is a super key?

622






What are different types of clusters present?

597


What is the function of cluster index?

612


What are different types of data models available? Explain with example?

659


sparse lookup and where its options we find in OCI and db2?

1741


What are the advantages of normalizing a database.

596


what is rcp,if rcp disabled what happen?

1710


What is the purpose of TNS?

656


Explain alternate key?

647


How concurrency problems effect the database?

631


What is the database url?

550