what is the difference between primary key & foreign key?
Answer Posted / hardik patel
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity.
| Is This Answer Correct ? | 65 Yes | 20 No |
Post New Answer View All Answers
How do I limit the number of oracle database connections generated by weblogic server?
Design database draw er diagram for a certain scenario ?
what is insert all statement in sql
How to write a query with a left outer join in oracle?
How to execute the package in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Briefly explain what is literal? Give an example where it can be used?
What is a system tablespace?
How different is ms access and oracle?
What is different types of joins?
What is the difference between PFILE and SPFILE in Oracle?
What happens if variable names collide with table/column names?
What are the predefined tablespaces in a database?
How to export data with a field delimiter?
Difference between oracle's plus (+) notation and ansi join notation?