SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

What is ON DELETE CASCADE?

SQL Interview Question
SQL Interview Question

Answer:

When ON DELETE CASCADE is specified Oracle maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is SQL ROWID?What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type?