what is the difference between primary key & foreign key?
Answer Posted / mohammadazam
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 ? | 17 Yes | 6 No |
Post New Answer View All Answers
What are a query and state the different types of queries and their uses?
What is max rowid in oracle?
Why packages are used in oracle?
How to insert a new row into a table in oracle?
Difference between the “verify” and “feedback” command?
How to connect to the server with user account: sys?
How does the on-delete-cascade statement work?
How to use subqueries in the from clause in oracle?
What is a named program unit?
What happens to the indexes if a table is recovered?
Differentiate between translate and replace?
State any two functions of oracle?
What are the differences between char and varchar2 in oracle?
What is oracle update statement with inner join ?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?