Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 138996 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
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
What the is the diff between local index and global index. give some example.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How do I spool in oracle?
Explain about functional dependency and its relation with table design?
What are the general rules on data consistency?
How to set up autotrace for a user account?
How many types of cluster table in Oracle?
How to sort the query output in oracle?
What is an oracle tablespace?
What is merge in oracle?
How to grant create session privilege to a user in oracle?
How to define a record variable to store a table row?
Hi Can any one tell me what are the API's used in requisition import.
How to rename an index?
What is system tablespace?
