what is the difference between primary key & foreign key?
Answer Posted / suraj menon
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to empty your oracle recycle bin?
How do I limit the number of oracle database connections generated by weblogic server?
Explain the use of full option in exp command.
How do I reset a sequence in oracle?
Why do you use stored procedures and state some of its disadvantages?
Describe the types of sub query?
State and explain the different types of data models?
How to assign query results to variables?
What is a database schema in oracle?
What is oracle analytical function?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What are the differences between interval year to month and interval day to second?
How can you use check constraints for self referential integrity?
How to define a data field as not null?