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
Is the After report trigger fired if the report execution fails ?
What is the difference between formal parameters and actual parameters?
How to turn on or off recycle bin for the instance?
What are the advantages of oracle 12c?
How to add a new column to an existing table in oracle?
What is oracle rowcount?
Explain what are synonyms used for?
Explain the use of full option in exp command.
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to call a sub procedure?
What is MTTR advisor in Oracle?
What is the relationship among database, tablespace and data file?
What are the restrictions on external table columns?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?