What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?
(a) transparent
(b) concrete
(c) elaborate
(d) cascaded
(a) transparent
(b) concrete
(c) elaborate
(d) cascaded
Right choice is (d) cascaded
The best explanation: In MySQL, a cascaded delete and update are possible where records can be deleted from multiple tables. These tables are related with the help of foreign keys. Foreign keys make table updates flexible.