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

Answer Posted / siya

Primary Key:- The primary key is the key which is uniquely
identifing in a table which not take null value for that
particular field and we don't take dublicate value for that
key.


Foreign Key:- Foregin Key is a key which define the primary
key into another table or any particular field of primary
key.

Is This Answer Correct ?    14 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain entity set?

583


What are the various ways to execute a query in teradata?

2193


How to do Stored procedure testing? Who does this testing (Developer or tester)?

1383


What is the use of default key?

625


How to do Data integrity testing? Who does this testing (Developer or tester)?

1608






What is ole db in ssis?

610


Is it good to store images in database?

546


During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

948


What are the advantages of using database?

548


What is meant by distributed system?

535


What is Object Oriented model?

618


What is the difference between a stored procedure and a query?

588


What is a trace file?

632


I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1193


What is the difference between primary and candidate key?

576