what is the difference between primary key & foreign key?
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
What is the maximum number of triggers that can be applied to a single table?
What is the difference between a user and a schema in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the difference between primary key and unique key and foreign key in oracle?
List the various oracle database objects?
Explain what are the advantages of views?
How to create a new table in your schema?
Explain a data segment?
How to view existing locks on the database?
What is the order of defining local variables and sub procedures/functions?
Explain the use of record option in exp command.
Why does oracle 9i treat an empty string as null?
How to create a new table in oracle?
How oracle handles dead locks?
How do I manually uninstall oracle client?