What is the self-referencing constraint ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the self-referencing constraint ?

The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

(Continued on next question...)

Other Job Interview Questions

• What is correlated subquery ?
• What is a buffer pool ?
• What is the difference between group by and order by ?
• What is normalization and what are the five normal forms?
• What is an inner join, and an outer join?
• What is the purpose of the DSNC transaction?
• What is JOIN and different types of JOIN ?
• What does DML stand for and what are some examples of it?
• Suppose I have a program which uses a dynamic SQL and it has been performing ...
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• More...