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 to display employee records who gets more salary than the average salary in the department?
Give the different types of rollback segments.
How do I know if oracle is installed on windows?
How many types of tables are there in oracle?
what is a Nested Loop join?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to shutdown your 10g xe server from command line?
What privilege is needed for a user to create views in oracle?
What are the uses of linked server and explain it in detail?
How to omit columns with default values in insert statement in oracle?
What is the oracle implicit cursor?
What are the uses of Database Trigger ?
What is pragma autonomous transaction in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?