What is the self-referencing constraint?
- 2 Answers
- 6531 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 |
Explain the use of the WHERE clause?
What is catalog database in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Could anyone clearly explain the diference between sub query and correlated sub query?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What is the maximum No of rows per page?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How does db2 sample database connect?
Describe the elements of the SELECT query syntax?
What is the purpose of the DSNC transaction ?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
COBOL 
