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 different types of record groups in oracle? Explain each of them
How to write an inner join with the where clause in oracle?
How do I spool to a csv formatted file using sqlplus?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What privilege is needed for a user to query tables in another schema?
Point out the difference between user tables and data dictionary?
How to execute a stored program unit?
What are set operators?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is memory advisor in Oracle?
Differentiate between translate and replace?
How to define and use table alias names in oracle?
Give the various rollback segment states.
what are bitmap indexes? How does they work?
How to increment dates by 1 in oracle?