what is the difference between primary key and foreign key

Answer Posted / s g



Primary key is used to identify a row in a table and it
doesnot allow null values. It avoids duplication of rows.

whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

3. In a system designed to work out the tax to be paid: An employee has £4000 of salary tax free. The next £1500 is taxed at 10%. The next £28000 after that is taxed at 22%. Any further amount is taxed at 40%. To the nearest whole pound, which of these groups of numbers fall into three DIFFERENT equivalence classes?

1684


in the account there is 10,000 rupees and i entered 20000, in this case how will you test the application

1249


What are the standard you follow in your company to prepare test plan document? Content is same in every standard or not. Also is there any document to read about the testing standards? Thanks in advance for giving me the answer.

1533


I have 2 years of exp. in testing and looking for a change if any body knows, about any vacancy in testing then plz contact me on deepti_ac@yahoo.co.in

7725


hi sir, i completed my GNIIT from NIIT. i recently joined in IT company for Testing(manual) on JD EDWARDS.So,i wanna to ask that after taking 1yr experience can i able to do Testing .NET in another company.Pl i am confused pl send yours suggestion throw my email(paresh_shindeal@yahoo.com)

1512






What is rapid application development model (rad)?

713


anybody there with 3+ exp in software testing looking for change and like to work in bangalore fwd your resume to vinodhanandhan@gmail.com

1733


What are testing techniques? What is difference between general and specific?

1557


How much the bug is affecting the functionality of the application?

626


how to write test cases for epos/pos testing.

9687


What is AGP?what is setup.inf?What are the ways to install driver?

1774


Does an increase in testing always improve the project?

1333


1.What types of documents would you need for QA, QC, and Testing?

4892


If automating - what is your process for determining what to automate and in what order

1519


How do you determine user soad for a perf test of a Web application?

1864