what is the difference between primary key & foreign key?
Answer Posted / suneel manne
Primary key is a key it will allow only Unique values and
avoid duplicate values and foreign key is a reference key
from the other table, So here primary key acts as a parent
key and foreign key acts as a child key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to rename an index in oracle?
Is primary key indexed by default in oracle?
How to create a new table by selecting rows from another table?
What happens to the indexes if a table is recovered?
What is the difference between primary key and unique key and foreign key in oracle?
Explain alias?
What are the logical operations?
What is the relation of a user account and a schema in oracle?
What is a directory object?
What are the different types of database objects?
What is MTTR advisor in Oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Explain parameter file in oracle.
What is the purpose of save points in oracle database?
Why does Oracle not permit the use of PCTUSED with indexes?