Interested to Buy Any Domain ? << Click Here >> for more details...
What is the cascade rule and how does it relate to
deletions made with a subselect?
- 1 Answers
- 5459 Views
- I also Faced
- E-Mail Answers
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 are concurrency issues?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
Explain db2.
What is cursor stability?
What do you mean by commit and rollback?
what is the difference between normal select query and currosor
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
How to insert more than one record using insert?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
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 ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is Reorg Recovery? when will you run it?
COBOL 
