what is the difference between primary key & foreign key?
Answer Posted / ibrahim
A primary key is an combination of attributes that uniquely
identifies each row in a relation. A primary key is
designated by underlining the attribute name. The primary
key of an entity set allows us to distinguish among the
various entities of the set.
A foreign key is an attribute in a relation of database
that serves as the primary key of another relation in the
same database.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the system predefined user roles?
What are the differences between blob and clob in oracle?
How to rename an existing table?
What is ceil and floor in oracle?
What is the Tune Query
What is a cognitive schema?
What is oracle host variable?
What is the best way to do multi-row insert in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
Does oracle charge for java?
How do I uninstall oracle client from windows?
How to declare a local variable?
Write a trigger example in oracle?
Why use resource manager in Oracle?
What is the quickest way to fetch the data from a table?