what is the difference between primary key & foreign key?
Answer Posted / navane
Primary key is a keyword.
It should not have null value and duplicate value.
We can have only one primary key in a table and the value
should be unique.
Foreign key is a keyword.
It can have null value and duplicate value.
We can have more than one foreign key for a table and this
froeign key table references the primary key table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why oracle is used?
How to create a stored function in oracle?
Is oracle an open source?
How remove data files before opening a database?
How to define a variable to match a table column data type?
Can we store images in oracle database?
what is IDE,DMV in sql server?
What are the various types of snapshots ?
Which are the five query types available in oracle?
What is a static data dictionary in oracle?
What are a cluster and non-cluster index?
What is oracle server autotrace in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
what is reindexing?
What is a nvl function?