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 are the three types of page locks that can be held?
Explain the function done by data manager?
What do you mean by cursor?
What is the reason behind not using select * in embedded sql programs?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What does the CHECK Utility do ?
What is scrollable cursor in db2?
Name the various locking levels available?
Describe what a storage group(STOGROUP) is?
what is differnece between DROP TABLE & DELETE TABLE .
Name the lockable units in DB2?