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

Answer Posted / mohamed ibrahim

Primary Key :- Is a unique identify a table data,it is avoid null and duplicate value.In a table we can assign single primary key.

Unique Key :- Is same as primary key but it allow single null value and avoid duplicate value.In a table we can assign more than one no of unique key.

Foreign Key :- Is a connect two table from a single column name.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1432


What is odm in database?

588


What are the advantages of normalizing a database.

602


What is dialect in database?

563


What is the difference between oracle and MS Access?

618






How to produce such kind of file?

635


What are the advantages of views in a database?

646


How heap is implemented in database?

644


define primary key index, bitmap index, hash index,virtual indwx

2850


You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

788


Explain data independence & its types.

594


Explain the various types of normalization.

648


how node connect with cpu?

1671


How to shrink a database?

546


what is rcp,if rcp disabled what happen?

1716