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 to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

1583


What are the most common databases?

537


What does currency type mean in database?

715


diff b/w inter process and in process

1548


Write a query to get maximum and second maximum in oracle?

596






What is a database lookup?

564


Is data lake a database?

559


Explain natural key?

614


how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1098


Is database a hardware or software?

536


What is odm in database?

576


How do I manually create a database?

560


What is the concept of Virtual field?

1613


Explain database partitioning. What is its importance?

671


Explain about ur projets on teradata???

1352