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 |
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
db2 restart logic ?
What are the isolation levels possible ?
What do you mean by commit and rollback?
What is the purpose of the DSNC transaction ?
What is table space in db2?
What is a collection in db2?
What is dbrm in db2 database?
What is the difference between dbm cfg and db cfg file in db2 ?
What are data types?
what is a plan and how do you refer the plan in the program?
How do you define a correlated name?