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 does one get the view definition of fixed views/tables?
What is a trace file and how is it created in oracle?
What is truncate oracle?
What are the different windows events activated at runtime ?
How to connect to the server with user account: sys?
How to create lov dynamically at runtime & attach to text field?
how to clone 9i Database on to 10g Database.
What is a oracle database?
What do you mean by a tablespace?
What is clustered table in Oracle?
How to check the server version in oracle?
What is coalesce function?
Explain what are the characteristics of data files?
What are the database administrators utilities available?
How to execute the package in oracle?