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

Answer Posted / inderjeet yadav

Primary key:A key which is uniquely indetified a row in a
table and primary key can not be null.

Unique key: A key which is uniquely indetified a row in a
table and but unique key can be null.

Foreign:Primary key of the first table that refering in
second table is know as foreign of second table.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of blocks used in stored procedure?

633


what is transaction state, buffer management, shadow paging

2931


What is odm in database?

588


What are the advantages of using database?

554


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

1849






What is a Database?

597


What is ole db used for?

586


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

2129


How to shrink a database?

546


Which three commands cause a transaction to end?

597


First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1312


Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1583


What is the importance of database partitioning?

615


What are database connection details?

648


Differentiate between extension & intension?

877