what is the difference between primary key & foreign key?
Answer Posted / guest
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 ? | 155 Yes | 19 No |
Post New Answer View All Answers
What is a schema in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is define in oracle?
Who developed oracle & when?
What is the difference between view and materialized view in Oracle?
What is the difference between translate and replace?
definition of cluster and non-clustered index?
What is the scope of a local variable?
How to do paging with oracle?
How many file formats are supported to export data?
How to specify default values in insert statement using oracle?
How to join two tables in a single query using oracle?
Explain rename?
Explain the types of exception?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?