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

Answer Posted / rama

primary key:primary key is not allowed null values and
duplicate values.
unique key: this key allows null values but does not allow
duplicate values.
foreign key:
this key is used to refer another table.(i.e)other table
primary key values is used in foreign key table.it makes
relation ship between two tables.

Is This Answer Correct ?    19 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define stored procedure?

601


How to produce such kind of file?

625


can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2101


What is meant by distributed system?

535


Explain about ur projets on teradata???

1355






What does currency type mean in database?

720


Is hive a database?

558


Display the employees whose salary is less than average salary.

634


How do database connections work?

496


What is Data Modelling?

632


diff b/w inter process and in process

1558


WHAT IS CARDINALITIES OF JOIN?

1922


What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

1581


What is the role of driver manager?

587


What is the difference between data source and database?

543