what is difference between foreign key and reference key
Answer Posted / soujanya
Foreign key is the key i.e. attribute which refers to
another table primary key. Reference key is the primary key
of table referred by another table.
| Is This Answer Correct ? | 37 Yes | 16 No |
Post New Answer View All Answers
What is the implicit cursor in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What do you understand by a database object?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Why do we use coalesce function in oracle?
What is SQL access advisor in Oracle?
What is SQL Tuning Advisor in Oracle?
Whats the benefit of dbms_stats over analyze?
What is the minimum client footprint required to connect c# to an oracle database?
Can a parameter be passed to a cursor?
How to use group functions in the select clause using oracle?
How are extents allocated to a segment?
How to define an anonymous block?
In oracle there is column command, how will you explain that?