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

Answer Posted / rahul patil

PRIMARY key is one which uniquely identifies a row in the
table.
It does not has any null value entry.It can be formed by
using one or more fields of the table.If more fields are
used then the key is known as COMPOSITE key

Is This Answer Correct ?    6 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the full procedure for using store procedure in informatica7.1?

1815


What are the types of indexes that are present inside a database?

643


if i want to display the name of students such that to which city they belong must have count greaer than two

1784


aht is the difference b/w network & hierarchial & relational dbms????

1775


Explain database partitioning.

646






How do I manually create a database?

570


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

1196


Is redis in memory database?

543


What are different types of clusters present?

605


What is the use of default key?

632


What is ole db ado?

555


i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?

1642


When should you not use firebase?

615


What is the purpose of TNS?

664


How many types of locks are present in a database?

610