Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is the cascade rule and how does it relate to
deletions made with a subselect?

Question Posted / guest


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

Post New Answer

More DB2 Interview Questions

Is schema the same as database?

0 Answers  

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

What are the three types of page locks that can be held?

1 Answers  

What is access path in db2?

0 Answers  

Explain what a plan is?

3 Answers   CTS,

Is db2 relational database?

0 Answers  

How would one remove old reorg information from the DB2 catalog?

2 Answers  

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

What are the Isolation levels possible ?

5 Answers  

What is a db2 package?

0 Answers  

For more DB2 Interview Questions Click Here
Categories