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
Point the difference between translate and replace?
What is integrity and what is constraint??Explain with example
how can we store any pdf file in oracle
How to write a left outer join with the where clause in oracle?
What are the restrictions in a oracle read only transaction?
What is a sub query? Describe its types?
What are the attributes that are found in a cursor?
Can we create database in oracle using command line ?
How to define a procedure inside another procedure?
How to select some columns from a table in oracle?
How to convert characters to dates in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
What is the database name in oracle?
What are a query and state the different types of queries and their uses?
Explain the use of owner option in exp command.