Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is ON DELETE CASCADE?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is ON DELETE CASCADE?..

Answer / tulsi

The main use of ON DELETE CASCADE is to delete the child
records automatically from a table when the related records
from master table is deleted.

Assign the ON DELETE CASCADE clause while creating the
foreign key

Is This Answer Correct ?    17 Yes 0 No

What is ON DELETE CASCADE?..

Answer / vilas

Yes,its true and won't display any error while deleting the
master table.

Is This Answer Correct ?    5 Yes 1 No

What is ON DELETE CASCADE?..

Answer / ansupriya

If child record exists user cannot delete parent record.
Using on delete cascade on foreign constraint user can delete parent record .
Same time automatically it will delete the child record.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

what is query cache in mysql? : Sql dba

0 Answers  

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

Is sql database free?

0 Answers  

What are the most important characteristics of pl/sql?

0 Answers  




Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

what are all different types of collation sensitivity? : Sql dba

0 Answers  

Wat is SGA ?

3 Answers   ABB,

How does a trigger work?

0 Answers  

Can you call pl/sql package functions from within a fast formula?

0 Answers  

What is pivot table in sql?

0 Answers  

What does t sql mean?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories