Suppose R and S are 2 relations. R is the parent of S. And the relationship between R and S is set to "ON DELETE CASCADE". This means that:

Suppose R and S are 2 relations. R is the parent of S.
And the relationship between R and S is set to
"ON DELETE CASCADE".
This means that: 




a. We can delete a row from R if that row has children in S (and in this case, the database server will raise up an error)
b. We can delete a row from R although that row has children in S (and in this case, all the children will be deleted too)




Answer: B


Learn More :