What is the self-referencing constraint?
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 |
Q3. How will you fetch duplicate values from a DB2 table?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is bind plan?
What is load utility in db2?
what is the difference between normal select query and currosor
How to update more then one record using update?
what is parm utility
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Explain dclgen.
What is the STOSPACE Utility used for?
what is the difference between join and union?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?