what is the difference between primary key & foreign key?
Answer Posted / mathiyarasan
Primary is unique one. Each table has only one primary key.
But not allow null values.
Foreign key is opposite of primary. It is reference of
primary key from another table. It allow Null value. Each
table can have more than one foreign key.
Foreign key is used to link one to another table.
| Is This Answer Correct ? | 22 Yes | 7 No |
Post New Answer View All Answers
What is bulk collect in oracle?
What is a cursor variable?
What is a private synonym?
How to create a new table in oracle?
How to create a table interactively?
What are joins, explain all types of joins?
How to define an explicit cursor in oracle?
What do you mean by a tablespace?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to connect to oracle using service name instead of sid?
How to define a variable of a specific record type?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to change user password in oracle?
What is a sub query and what are the different types of subqueries?
What are the four Oracle system processes that must always be up and running for the database to be useable?