what is foreign key?
Answers were Sorted based on User's Feedback
Answer / guest
foreign key reference as Primary key in another table
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ramprakash
Foreign keys enforce referential integrity by completing an
association between two entities.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / guest
It's a constrains assigned to a column or combination of
columns included in the definition of referential integrity
which would refer to a referenced key
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sejal
A foreign key is a link or relationship between two tables
which ensures that the data stored in a data-
base is consistent.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kebiraj
A foreign key, also called a foreign keyword, in a database
table is a key from another table that refers to (or
targets) a specific key, usually the primary key , in the
table being used. A primary key can be targeted by multiple
foreign keys from other tables. But a primary key does not
necessarily have to be the target of any foreign keys.
by
kebiraj.s
Is This Answer Correct ? | 0 Yes | 0 No |
Point the difference between translate and replace?
What is hash cluster in oracle?
What is a subquery?
What is meant by recursive hints ?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
Describe an oracle table?
Write a syntax for update query in oracle?
How to rebuild an index in oracle?
What are the limitations oracle database 10g xe?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Can a parameter be passed to a cursor?