what is the difference between primary key & foreign key?
Answer Posted / gaurav , ashish ,preeti , main
Primary key is used to identify a row in a table 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 ? | 57 Yes | 16 No |
Post New Answer View All Answers
How to change program global area (pga) in oracle?
How to create a new oracle data file?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is the disadvantage of User defind function?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to add a new column to an existing table in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
how do u setup a replication site?
How to unlock the sample user account in oracle?
What are the differences between lov and list item?
What do you mean by merge in oracle and how can we merge two tables?
What are nested tables?
how to join query for one source type is oracle another source type is sql server ?
What is an Oracle Instance?
Explain what are synonyms used for?