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

Explain phantom deadlock?

958


List various types of log-based recovery in DBMS.

734


Is it good to store images in database?

741


Is hive a database?

706


What is redis good for?

733


Write a query to retrieve for many to many relationships?

745


How does non-cluster index functions?

842


What are different types of resources?

715


Which database is best to store images?

746


HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

2150


What is difference between data and database?

740


5. Explain about relational algebra.

1917


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

2021


Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2002


Is database a hardware or software?

747