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
Which environment variables are absolutely critical in order to run the OUI?
How to convert characters to times in oracle?
What is the use of aggregate functions in oracle?
How to convert times to characters in oracle?
How to rename an existing table?
How to declare a local variable?
In the oracle version 9.3.0.5.0, what does each number shows?
What privilege is needed for a user to create tables in oracle?
How to select an oracle system id (sid)?
How to assign values to data fields in record variables?
Explain table?
What is system global area (sga) in oracle?
What operating systems are supported by oracle database 10g xe?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is a nested table and how is it different from a normal table?