What is the cascade rule and how does it relate to
deletions made with a subselect?
Answer / s
Cascade deletes the foreign keys when the primary key is
delted.
When using subselect the rows deleted are based on the rows
that qualify for the subselect.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is an instance in db2?
How are write I/Os from the buffer pool executed?
What is difference between isnull and coalesce?
What are the contents of dclgen?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
wht happens if we close cursor with cursor with hold option?
Where is the output of EXPLAIN stored?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What is db2 optimizer?
What is -904 sql code? How to resolve it?
How many clustering indexes can be defined for a table?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??