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
State and explain the different types of data models?
What is transport network substrate (tns) in oracle?
How to convert numbers to characters in oracle?
Can we write dml statement in function in oracle?
How do I spool in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
6. Display the client name and order date for all orders using the traditional method.
How to unlock the sample user account in oracle?
Define oracle database
What are the restrictions in a oracle read only transaction?
How to view all columns in an existing table?
What is dynamic proxy?
How to use like conditions in oracle?
What happens to the current transaction if the session is ended?
What is transaction control statement and how many types of transaction control statement in Oracle?