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 is a nvl function?
Explain do view contain data?
candidate key is subset of super key but not vice-verse explain
What is a cursor variable?
What are the database administrators utilities available?
How to concatenate two text values in oracle?
material view and view disadvantages?
How to write date and time interval literals in oracle?
How to unlock the sample user account in oracle?
Explain what are the different type of segments?
What is ordinary table in oracle?
Can select statements be used on views in oracle?
Can I create users through internet explorer in oracle 10g?
Why does oracle 9i treat an empty string as null?
Can sub procedure/function be called recursively?