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 java oracle used for?
Respected sir, Please send me technical questions related to oracle apps..
How can we find out the duplicate values in an oracle table?
Explain the use of consistent option in exp command.
How to specify default values in insert statement using oracle?
What would you do with an in-doubt distributed transaction?
What is the parameter mode that can be passed to a procedure?
How to define an explicit cursor in oracle?
What is the relationship among database, tablespace and data file?
How many categories of data types in oracle?
What are the general rules on data consistency?
Does oracle partitioning improve performance?
What is analyze command used for?
How to create a testing table in oracle?
What happens to indexes if you drop a table?