When you Enforce Referential Integrity between the tables, you have two Cascading choices. What is the effect of enabling the Cascade Delete option?

Question

When you Enforce Referential Integrity between the tables, you have two Cascading choices. What is the effect of enabling the  Cascade Delete  option?

Accepted Answer

It ensures that all the related records will be deleted automatically when the related record in the parent table is deleted.

Answer

It ensures that you cannot change or delete the primary key value in the primary table that is used in a relationship with another table.

Answer

It repeats the recent delete operation to all the records of current table.

Answer

It causes all the records of all tables in a database to be deleted.

Answer

It changes the foreign key value of all related records when the primary key value in the parent table is deleted.

Crowdly

When you Enforce Referential Integrity between the tables, you have two Cascadin...

Want instant access to all verified answers on connect.belgiumcampus.ac.za?