Interested to Buy Any Domain ? << Click Here >> for more details...
What is the self-referencing constraint?
- 2 Answers
- 6374 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Self-referencing constraint makes the table both the parent
and dependent table in the same referential constraint. The
foreign key to the table is defined after the table is
created.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mehdee
- To me it is when we create DB2 table and we use options
like, for example:
CONSTRAINT BONUS CHECK(BONUS <= SALARY)
OR
RESTRICT ON DROP
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the syntax required for the creation of a cursor?
When will you chose to run RUNSTATS?
what is the difference between where clause and having clause
What is a clustering index?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is a result table?
What techniques will be used to avoid deadlock??
When the like statement is used?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
Where are plans stored?
What is reorg in database?
Why do we bind in db2?
COBOL 
