IBM DB2 Question:
Download Questions PDF

What is the self-referencing constraint?

Answer:

A31. 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.

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext Question
Is DECLARE CURSOR executable?A user
defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.

In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.