Foreign key is the key i.e. attribute which refers to another table prima

what is difference between foreign key and reference key

Question Posted / soujanya

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

Please Help Members By Posting Answers For Below Questions

What is the implicit cursor in oracle?

1165

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

1024

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2086

What do you understand by a database object?

1103

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1989

Why do we use coalesce function in oracle?

1162

What is SQL access advisor in Oracle?

1225

What is SQL Tuning Advisor in Oracle?

1240

Whats the benefit of dbms_stats over analyze?

2064

What is the minimum client footprint required to connect c# to an oracle database?

1157

Can a parameter be passed to a cursor?

1178

How to use group functions in the select clause using oracle?

1126

How are extents allocated to a segment?

1177

How to define an anonymous block?

1240

In oracle there is column command, how will you explain that?

1131