PRIMARY KEY ------------- Primary key is a column in a table which is hav

what is the difference between primary key & foreign key?

Question Posted / vaziuddin shaik

57 Answers
138995 Views
CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
E-Mail Answers

Answer Posted / vaziuddin shaik

PRIMARY KEY
-------------
Primary key is a column in a table which is having unique
values......and it does not contain null values and
duplicate values...........

FOREIGN KEY
-------------
Foreign key is a column in a table which act as reference to
another table.....and it may contain null and duplicate
values.....(or)it may not contain null and duplicate
values...........

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Write a trigger example in oracle?

1110

What is the difference between 10g OEM and 11g OEM?

1015

Why we use bulk collect in oracle?

1111

How to create a new oracle data file?

1074

Compare and contrast between sql and sql server and explain its various functions?

1015

Explain the use of log option in exp command.

1181

How do you bind variables in oracle?

1018

Is oracle an open source?

1124

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2305

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2173

Explain compound trigger in oracle?

1087

How to return top 5 rows in oracle?

1112

Can we protect our pl/sql source code?

1080

Explain how you would restore a database using RMAN to Point in Time?

2183

How to open a cursor variable?

1084