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

Answer Posted / nitin kumar

A primary key is one which uniquely identifies a row of a
table. This key does not allow null values and duplicate
values.

A foreign key is one which identifies a set of columns in a
table or enforce link between the in two tables.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is image stored in database?

763


Under which circumstance should you create an index on a table?

861


A lowest level of security by most RDBMS is

855


Why do we need distributed database?

733


what are wrappers and build ups and what it's use?

1893


What are indexes in oracle?

836


What do you mean by database?

761


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

1963


What are different types of clusters present?

791


Difference between sql and mysql?

1809


Write a query to retrieve for many to many relationships?

748


How many types of locks are present in a database?

796


Is data lake a database?

740


Explain normalization in one line?

815


How to do performance tunning a database in DB2 V8.2 UDB in linux

2025