what is the difference between primary key & foreign key?
Answer Posted / altaf ali
primary key of a relation is a candidate key that has been
designated as the main key.It doesn't has null value.
A foreign key is an attribute in a relation that can be
used as a key to another relation.It allow null and
duplicate value.
Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
How to create a new view in oracle?
How to create an oracle database?
List out the components of logical database structure of oracle database.
What are the roles of dba?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to assign a table row to a record variable?
Explain the use of Merge statement in oracle 11g
What are the execution control statements in oracle?
How to view existing locks on the database?
How to delete multiple rows from a table in oracle?
How to start an oracle instance?
How to write numeric literals in oracle?
How do we get field detail of a table?
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 is max rowid in oracle?