what is the difference between primary key & foreign key?
- 57 Answers
- 122367 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / shaik gouse peer
Basic difference betweeen Primary key and foreign key is :
Primary key will not allow "Null values" and "Duplicate
values"
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 130 Yes | 25 No |
Post New Answer View All Answers
What is the scope of a local variable?
How to pass a parameter to a cursor in oracle?
What are the types of trigger in oracle?
What is logical backup in oracle?
Differentiate between function and procedure in oracle.
How can I see all tables in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain an exception?
What are oracle functions?
How to lock and unlock a user account in oracle?
How to store pictures on to the database?
Give the advantages and disadvantages of clusters.
Is there an oracle sql query that aggregates multiple rows into one row?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is system global area (sga) in oracle?
