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

When can Hash Cluster used ?

How to create a new oracle data file?

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

How do I connect to oracle database?

Explain drop constraint oracle?

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

write a query that displays every Friday in a year with date?

How do we get field detail of a table?

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

what are different types of locks?

State and explain about oracle instance?

Explain what are the uses of rollback segment?

For more Oracle General Interview Questions Click Here