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

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

Question Posted / bikram

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

How are extents allocated to a segment?

How do you handle duplicate records in a database?

What are the differences between blob and clob in oracle?

What is the use of file param in imp command?

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

What is a Temporary Segment ?

What are the values that can be specified for OPTIMIZER MODE Parameter ?

How are the index updates?

What is a recycle bin in oracle?

Explain can a view based on another view?

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

For more Oracle General Interview Questions Click Here