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
How to define an anonymous procedure with variables?
What is a proxy class?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What do you mean by a database transaction & what all tcl statements are available in oracle?
query optmization techniques and quwry analyser+projects+ppts
Can we write insert statement in function in oracle?
definition of cluster and non-clustered index?
How do I escape a reserved word in oracle?
Why is oracle used?
How to use "in out" parameter properly?
How do I recompile a procedure in oracle?
what is a Nested Loop join?
What is sequence?
How to check the oracle tns settings?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?