what is the difference between primary key & foreign key?
Answer Posted / altaf ali
primary key of a relation is a candidate key that has been
designated as the main key.It doesn't has null value.
A foreign key is an attribute in a relation that can be
used as a key to another relation.It allow null and
duplicate value.
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
How to create a stored procedure in oracle?
Is oracle a language?
Explain what are the different type of segments?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Explain oracle left join with an example?
What is the data pump export utility?
What language does oracle use?
What is system tablespace?
State and explain about oracle instance?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Explain the use of indexes option in imp command.
Can we commit inside a function in oracle?
What are internal user account in oracle?
How can I introduce multiple conditions in like operator?
How to create a table index?