Deletion of an employee from table also deletes that employee

deletion-of-an-employee-from-table-also-deletes-that-employee

Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________

A. transparent

B. concrete

C. elaborate

D. cascaded

I got this question during an online exam.

I want to ask this question from Foreign Keys and Referential Integrity topic in division Using SQL to Manage Data of MySQL

The correct option is D. cascaded

Explanation: In MySQL, a cascaded delete and update is 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.